Re: OID wrap around - Mailing list pgsql-general

From Steve O'Hagan
Subject Re: OID wrap around
Date
Msg-id 9ekb6o$1bk9$1@news.tht.net
Whole thread Raw
In response to RE: OID wrap around  (<jeff.fitzmyers@managestar.com>)
Responses Re: Re: OID wrap around
List pgsql-general
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...
> 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



pgsql-general by date:

Previous
From: "Hector Morales"
Date:
Subject: problema con buffer de psql
Next
From: George Herson
Date:
Subject: Re: incomplete transaction keeps table locked?