[postgis-users] addgeometry not found

[Mike Leahy]

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
>