[Gdal-dev] ogr2ogr with PostgreSQL 8.1

[Bart van den Eijnden (OSGIS)]

Hi Frank,

this is indeed new in PostgreSLQ 8.1. By default tables are created 
without oids.

At the end of the SQL you would just use WITH OIDS.

But see my last post, to me there is no apparent need to do this.

Best regards,
Bart

Frank Warmerdam wrote:

>On 1/16/06, Bart van den Eijnden (OSGIS) <bartvde at xs4all.nl> wrote:
>  
>
>>Hi list,
>>
>>shouldn't the tables created by ogr2ogr explicitly specify WITH OIDS?
>>AFAIK all the Mapserver SQL assumes there is an OID column. I am using
>>the latest FWTools.
>>    
>>
>
>Bart,
>
>I gather that the need for WITH OIDS is something new,
>likely in Postgres 8.1?  How would I request OIDs when
>creating the table?
>
>Best regards,
>--
>---------------------------------------+--------------------------------------
>I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
>light and sound - activate the windows | http://pobox.com/~warmerdam
>and watch the world go round - Rush    | Geospatial Programmer for Rent
>
>
>
>  
>


-- 
Bart van den Eijnden
OSGIS, Open Source GIS
http://www.osgis.nl