OID wrap around
Someone mentioned the OIDs are unique for every row for an entire database cluster. I also notice that they are not being reused (like a sequence). Will they wrap around as soon as the 2^32 boundary is hit?
TIA,
thalis
Remembering past discussions: Yes OID's wrap around. When this happens,
they will not nesecarily be unique anymore. Apparently this should not
be a problem unless one has queries that specifically use OID's. INT8
OID's have been talked about and will probably be implemented some day.
Jeff
Someone mentioned the OIDs are unique for every row for an entire
database cluster. I also notice that they are not being reused (like a
sequence). Will they wrap around as soon as the 2^32 boundary is hit?
Import Notes
Resolved by subject fallback
But when I've finished calculating the 4 billion names of God, it wont
matter anyway - end of universe as we know it . . . ;-)
Regards.
SGO.
<jeff.fitzmyers@managestar.com> wrote in message
news:371EAC487A83CD4296F6999FD088D83305B725@atlas.managestar.com...
Show quoted text
Remembering past discussions: Yes OID's wrap around. When this happens,
they will not nesecarily be unique anymore. Apparently this should not
be a problem unless one has queries that specifically use OID's. INT8
OID's have been talked about and will probably be implemented some day.Jeff
Someone mentioned the OIDs are unique for every row for an entire
database cluster. I also notice that they are not being reused (like a
sequence). Will they wrap around as soon as the 2^32 boundary is hit?---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Steve O'Hagan wrote:
But when I've finished calculating the 4 billion names of God, it wont
matter anyway - end of universe as we know it . . . ;-)
Yepp, "as we know it".
At that moment the universe will be replaced by something
that, in contrast to the current placeholder, *makes sense*.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com