Re: OID wrap around

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(dot)fitzmyers(at)managestar(dot)com> wrote in message
news:371EAC487A83CD4296F6999FD088D83305B725(at)atlas(dot)managestar(dot)com(dot)(dot)(dot)
> 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(at)postgresql(dot)org