[postgis-users] Error using AddGeometryColumn

[Rick Schumeyer]

I'm using postgis 1.0.4 with postgresql 8.1.0.  I have previously created
and loaded a postgis database in this system, and everything seems to work.

In an attempt to test something, I created a different database and tried to
create the same tables, but this time I get an error, shown at the end.

 

(I have previously created a table "data").

 

I have no clue what this error means.

 

#create language plpgsql;

#\i /home/rick/ftp/postgresql-8.1.0/contrib/postgis-1.0.4/lwpostgis.sql

#\i
/home/rick/ftp/postgresql-8.1.0/contrib/postgis-1.0.4/spatial_ref_sys.sql

 

# select AddGeometryColumn('data','geom',2959,'POINT',2);

ERROR:  row "mislinked" has no field "attrelid"

CONTEXT:  compile of PL/pgSQL function "fix_geometry_columns" near line 80

SQL statement "SELECT  fix_geometry_columns()"

PL/pgSQL function "addgeometrycolumn" line 154 at select into variables

SQL statement "SELECT  AddGeometryColumn('','', $1 , $2 , $3 , $4 , $5 )"

PL/pgSQL function "addgeometrycolumn" line 4 at select into variables

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20051130/78cac2fb/attachment.html>