Re: Using oids - Mailing list pgsql-general

From Tom Lane
Subject Re: Using oids
Date
Msg-id 14686.1062624747@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using oids  (Jonathan Bartlett <johnnyb@eskimo.com>)
List pgsql-general
Jonathan Bartlett <johnnyb@eskimo.com> writes:
>>> If you want a globally unique ID based on OIDs, use the table OID
>>> concatenated with the row OID.

>> Ok, this make sense !

> Are you sure this works after you hit the 4 billion mark?

If you have a unique index on OID on each table for which you care, yes.

As someone else pointed out, you do then have to cope with the
possibility of insertions failing because of OID conflicts.

            regards, tom lane

pgsql-general by date:

Previous
From: Josué Maldonado
Date:
Subject: Re: TCL trigger doesn't work after deleting a column
Next
From: Bo Lorentsen
Date:
Subject: Re: Using oids