[postgis-users] Error using AddGeometryColumn

[strk at refractions.net]

Try make clean and re-make under postgis-1.0.4, and
check that USE_VERSION is set to 81.

It looks like the lwpostgis.sql you're using has
been produced for a previous version of postgresql.

--strk;


On Wed, Nov 30, 2005 at 09:54:43AM -0500, Rick Schumeyer wrote:
> 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
> 
>  
> 
>  
> 

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for open standards
  X     No HTML/RTF in email
 / \    No M$ Word docs in email