Обсуждение: Length of OID

Поиск
Список
Период
Сортировка

Length of OID

От
Michael Meskes
Дата:
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!


Re: [HACKERS] Length of OID

От
Tom Lane
Дата:
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