[postgis-users] addgeometry not found

John Taber jtaber at johntaber.net
Sun Jan 29 13:43:39 PST 2006


I forgot.  Good catch, thanks.

Mike Leahy wrote:
> John,
> 
> Did you load the PostGIS functions and spatial reference table into your
> database?  Chapter 2 of the PostGIS documentation covers those steps:
> http://postgis.refractions.net/docs/ (see section 2.2, steps 5 to 7).
> 
> Mike
> 
> John Taber wrote:
> 
>>It appeared that postgis compiled without errors and make installed
>>correctly but I'm getting the following errors.  Running postgis 1.1.1
>>and postgres 8.0 on ubuntu.  Any ideas:
>>
>>
>>>shp2pgsql -D Water.shp water testshape | psql testshape
>>>Shapefile type: Arc
>>>Postgis type: MULTILINESTRING[2]
>>>BEGIN
>>>NOTICE:  CREATE TABLE will create implicit sequence "water_gid_seq"
>>>for serial column "water.gid"
>>>NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>>"water_pkey" for table "water"
>>>CREATE TABLE
>>>ERROR:  function addgeometrycolumn("unknown", "unknown", "unknown",
>>>"unknown", "unknown", integer) does not exist
>>>HINT:  No function matches the given name and argument types. You may
>>>need to add explicit type casts.
>>>ERROR:  current transaction is aborted, commands ignored until end of
>>>transaction block
>>
>>_______________________________________________
>>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
> 
> 



More information about the postgis-users mailing list