Tom Lane wrote:
>
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >> Except for all the places that assume Oid is interchangeable with int.
> >> Finding them is left as an exercise for the student...
>
> > It would be nice to get OID to act as an unsigned 'int' in all places.
>
> Actually, I'd like to get rid of the assumption that it has anything
> to do with int. Signed or not is the least of my worries --- I'd like
> to be able to equate Oid to long long, for example.
So would I!
>
> regards, tom lane
BTW, the 32-bit oid implies a hard limit of 2 billion records on a single
server, right? What if that number hits ~2 billion over the course of
many inserts and deletes? Does it intelligently wrap back to 1 and find
holes in the sequence to re-use? Otherwise it's more than a limit on
records; it's a limit on inserts.
--
Paul Caskey paul@nmxs.com Software Engineer
New Mexico Software 5041 Indian School NE Albuquerque, NM 87110
--