Re: 4 billion + oids - Mailing list pgsql-general

From Tom Lane
Subject Re: 4 billion + oids
Date
Msg-id 19440.1048533408@sss.pgh.pa.us
Whole thread Raw
In response to Re: 4 billion + oids  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-general
"Dann Corbit" <DCorbit@connx.com> writes:
> I have definitely seen serious problems relating to OID wrap.
> We have an application that uses the OID's to create joins.
> We scan tables from a list of source tables from some external (usually
> non-postgresql) database.
> For each of these tables we create a 64 bit checksum for each record and
> store it in a table, along with an OID.

Why in the world aren't you using a serial int8 column, instead?

            regards, tom lane


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: 32/64-bit transaction IDs?
Next
From: "Dann Corbit"
Date:
Subject: Re: 4 billion + oids