Re: maximum number of rows in table - what about oid limits?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: maximum number of rows in table - what about oid limits?
Дата
Msg-id 9559.992011082@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: maximum number of rows in table - what about oid limits?  (Jonathan Bartlett <johnnyb6@sdf.lonestar.org>)
Ответы Re: maximum number of rows in table - what about oid limits?  (Jonathan Bartlett <johnnyb6@sdf.lonestar.org>)
Список pgsql-sql
Jonathan Bartlett <johnnyb6@sdf.lonestar.org> writes:
> Besides compatibility, what breaks when you make OIDs/Txn IDs
> INT8s?

OIDs are part of the on-the-wire protocol (column type data returned
during a SELECT is in the form of OIDs).  So extending OIDs to int8
would pose nontrivial client/server compatibility hazards.

> Maybe there should be a minor fork called Postgres64 which does
> this for those needing large tables.  

I've been thinking it should be a compile-time option.  But the protocol
issue is going to be a problem.
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: Luis Sousa
Дата:
Сообщение: Hidden Select
Следующее
От: Tom Lane
Дата:
Сообщение: Re: behavior of ' = NULL' vs. MySQL vs. Standards