[postgis-users] database wide unique ID

Guido Lemoine guido.lemoine at jrc.it
Mon Jul 23 07:55:14 PDT 2007


OK. I guess this is a good solution. I just thought OIDs as I
had some recent problems getting Postgis data displayed in
QGIS and PGAdmin (clients). If you don't have a primary key,
it tries to use OIDs for unique identifier. So you can tackle
2 problems in one go.


Stephen Frost wrote:
> * Guido Lemoine (guido.lemoine at jrc.it) wrote:
>> Use postgresql OIDs. These are "unique" object IDs.
> Do *not* use postgresql OIDs.
> Create a sequence and add a column to each table which defaults to
> nextval() on that sequence.  He's only talking about 3 tables anyway.
> 	Thanks,
> 		Stephen
> ------------------------------------------------------------------------
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Guido Lemoine
Joint Research Centre, European Commission
Institute for the Protection and Security of the Citizen (IPSC)
Unit: Support to External Security
Via E. Fermi, 1 TP 267 Ispra 21020 (VA), Italy
Tel. +39 0332 786239 (direct line) Fax. +39 0332 785154
WWW: http://ses.jrc.it
Views expressed are those of the individual and do not represent 
the views of the European Commission

More information about the postgis-users mailing list