Re: 64-bit sequences

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