Re: [HACKERS] Length of OID - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Length of OID
Date
Msg-id 7100.949014566@sss.pgh.pa.us
Whole thread Raw
In response to Length of OID  (Michael Meskes <meskes@postgresql.org>)
List pgsql-hackers
Michael Meskes <meskes@postgreSQL.org> writes:
> I saw that it is a 4 byte integer on my site, but is that guaranteed?

Yes, for now anyway.

Eventually I'd like to see us offering 8-byte OIDs, because a DB that's
been running for a while could wrap around the OID counter and produce
duplicate OIDs :-(.  But until support for 8-byte "long long int" is
pretty standard, I don't think we can do it without creating tremendous
portability problems.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Kristofer Munn
Date:
Subject: Orphaned files in the database...
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] TODO list check