[postgis-users] addgeometrycolumn() does not exist

[Gregory S. Williamson]

You needed to do the createlang, but also need some sql.

There is a file of commands that actually loads the sql interface to the GIS functions called "postgis.sql" that you want to run for your database. You may also want to run the "spatial_ref_sys.sql" to populate the spatial references table. These two files are found in the contrib postgis directory (e.g. /usr/src/postgresql-7.4/contrib/postgis-0.8.0, or some such). There is a 3rd sql file used to delete the GIS stuff from the database.

Greg Williamson
DBA
GlobeXPlorer LLC

-----Original Message-----
From:	Aaron Steele [mailto:asteele at berkeley.edu]
Sent:	Fri 6/4/2004 5:25 PM
To:	PostGIS Users Discussion
Cc:	
Subject:	Re: [postgis-users] addgeometrycolumn() does not exist
hi paul,

yes, i enabled pl/pgsql with 'createlang plpgsql <mydb>'. is this what 
you mean?

thanks,
aaron

On Jun 4, 2004, at 5:06 PM, Paul Ramsey wrote:

> Is it possible you have not enabled PostGIS by loading the postgis.sql 
> file?
>
> Aaron Steele wrote:
>
>> dear readers,
>> i'm running postgresql 7.4.2 with postgis 0.8.1 on linux redhat 8.
>> i successfully converted a shapefile (cnty24k97.shp from  
>> http://gis.ca.gov/BrowseCatalog.epl) into sql (shp2pgsql 
>> cnty24k97.shp  counties mapitdb > counties.sql). while uploading it 
>> to my database  (psql -d mapitdb -f counties.sql), i get this error:
>> <error>
>> psql:counties.sql:1: ERROR:  syntax error at or near "#" at character 
>> 76
>> psql:counties.sql:2: ERROR:  function addgeometrycolumn("unknown",  
>> "unknown", "unknown", integer, "unknown", integer) does not exist
>> HINT:  No function matches the given name and argument types. You may 
>>  need to add explicit type casts.
>> BEGIN
>> ...
>> psql:counties.sql:174: ERROR:  syntax error at or near "#" at 
>> character  51
>> psql:counties.sql:175: ERROR:  syntax error at or near "#" at 
>> character  51
>> COMMIT
>> psql:counties.sql:176: ERROR:  relation "counties" does not exist
>> psql:counties.sql:177: ERROR:  relation "counties_gid_seq" does not  
>> exist
>> </error>
>> here is a snippit from the converted shapefile:
>> <snippit>
>> CREATE TABLE counties (gid serial, AREA float8, PERIMETER float8,  
>> CNTY24K97# int4, CNTY24K97- int4, NAME varchar, NAME_CAP varchar, NUM 
>>  int4, FIPS_CODE int4);
>> select  
>> AddGeometryColumn('','counties','the_geom','-1','MULTIPOLYGON',2);
>> begin;
>> Insert into counties  (gid,AREA,PERIMETER,CNTY24K97#,CNTY24K97- 
>> ,NAME,NAME_CAP,NUM,FIPS_CODE,the_geom)  
>> values('0','2625844992.000000','306174.219000','2','3','Del 
>> Norte','DEL  
>> NORTE','8','15',GeometryFromText('MULTIPOLYGON(((-346072.6875  
>> 440055.6875 ,-346105.3125 440068.65625 ,-346134.65625 440091.03125  
>> ,-346175.34375 440118.75 ,-346328.84375 440208.3125 ,-346462.90625  
>> 440279.8125 ,-346547.65625 440322.875 ,-346624.65625 440345.6875  
>> ,-346687.46875 440362.0625 ,-346797.8125 440381.90625 ,-346850.78125  
>> 440393 ,-346927.84375 440413.84375 ,-346956.21875 440425.6875  
>> ,-347058.15625 440439.78125 ,-347101.46875 440440.09375 
>> ,-347178.28125  440433.4375 ,-347243.34375 440432.40625 
>> ,-347343.28125 440426.46875  ,-347395.28125 440426.03125 
>> ,-347449.1875 440415.6875 ,-347486.875  440412.34375 ,-347517.9375 
>> 440396.8125 ,-347558.875 440385.0625  ,-347583.40625 440385.812...
>> </snippit>
>> any thoughts?
>> thanks,
>> aaron
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> -- 
>       __
>      /
>      | Paul Ramsey
>      | Refractions Research
>      | Email: pramsey at refractions.net
>      | Phone: (250) 885-0632
>      \_
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>