[postgis-users] create spatial table problem

[Tyler Mitchell]

Hi Tom,

If your table was enabled to have oids, the SQL would have a trailing ... "WITH OIDS;" option added to the CREATE TABLE command.  i.e:

create table hydromet_stations (
 id serial primary key,
 stnid text,
 portfurl text,
 graphurl text,
 sensormlurl text,
 organization text
 ) WITH OIDS;

I guess pg_dumpall doesn't replicate this part of the environment.

Also, in postgresql.conf there is a setting that, I think you can enable to have oids by default when new tables are created.  

i.e.:
#default_with_oids = off

Tyler
----- Original Message -----
From: "Kralidis,Tom [Burlington]" <Tom.Kralidis at ec.gc.ca>
Date: Tuesday, February 21, 2006 9:38 am
Subject: RE: RE: [postgis-users] create spatial table problem

> 
> Not sure.  I do know that we moved the entire database (via 
> pg_dumpall)and inserted via psql -f <file> as we moved things 
> across servers.
> Everything else seems to be there (PostGIS enabled MapServer apps 
> work).Maybe the oid thing has to be turned on?  I do know we have 
> thesedefined for our previous spatial tables.  How would one 
> enable this?