Thread: 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