[postgis-users] addgeometry not found

[John Taber]

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