[postgis-users] database wide unique ID

Stephen Frost sfrost at snowman.net
Mon Jul 23 07:48:04 PDT 2007


* 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070723/f025b8b0/attachment.pgp>


More information about the postgis-users mailing list