[postgis-users] old data loads but not new ...

Sears, Jeremy Jeremy.Sears at CCRS.NRCan.gc.ca
Thu Mar 2 09:11:43 PST 2006


Hi 
Thanks for the suggestion. We have solved the problem.

Jeremy

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of alex
bodnaru
Sent: March 2, 2006 11:49 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] old data loads but not new ...



hi,

recent postgresql do not generate the oid column by default.
please check relevant issue on postgresql.org.

alex

Sears, Jeremy wrote:
> Hi All,
> Im having a problem with postgresql/postgis. We have been working with
this
> database for some time now. All of the tables that contain geometry have
> been created in older versions of post (7 - 8.0). We have upgraded since
> then and now use postgresql8.1 with updated postgis. Mapserver and Qgis
can
> connect to the older tables and display the geometry associated with them.
> We have recently added a new spatial table, using what I understand to be
> the same methodology that was used to add the other spatial tables.
Neither
> Mapserver nor Qgis can connect the this new table. The table is identical
to
> one of the older tables in everyway ( except the new table has different
> records ). QGIS give the following error when I try to connect to the new
> table:
> 
> ..thetable has no primary key nor oid column...etc .. the table should be
> indexed..
> 
> I have reindexed the database to no avail. Im relativly new to this so I
am
> hoping that someone on the list recoginizes this issue and can advise on
> what to do. Any thoughts or suggestions would be great!
> 
> Thanks
> Jeremy
> 
> _______________________________________________
> 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