Обсуждение: Length of OID
I saw that it is a 4 byte integer on my site, but is that guaranteed? Or how do I check for its length? That is I have to know how long a string has to be so the oid fits in ascii. Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!
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