[postgis-users] addgeometrycolumn() does not exist

[Aaron Steele]

dear readers,

thanks for everyone's help. the solution turnout out to be a 
combination of things. first i needed to load the sql interface 
(postgis.sql, spatial_ref_sys.sql). then i needed to edit the resulting 
sql file generated from shp2pgsl. all tuple variables containing '#' or 
'-' required surrounding double quotes. after these changes, it worked.

thanks,
aaron

On Jun 4, 2004, at 5:32 PM, Gregory S. Williamson wrote:

> 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
>>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>