Re: OID wrap around

Поиск
Список
Период
Сортировка
От Steve O'Hagan
Тема Re: OID wrap around
Дата
Msg-id 9ekb6o$1bk9$1@news.tht.net
обсуждение исходный текст
Ответ на RE: OID wrap around  (<jeff.fitzmyers@managestar.com>)
Ответы Re: Re: OID wrap around  (Jan Wieck <JanWieck@Yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: "Hector Morales"
Дата:
Сообщение: problema con buffer de psql
Следующее
От: George Herson
Дата:
Сообщение: Re: incomplete transaction keeps table locked?