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

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: [SQL] maximum number of rows in table - what about oid limits?
Дата
Msg-id Pine.BSF.4.21.0106061146090.16690-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответы Re: [SQL] maximum number of rows in table - what about oid limits?
Список pgsql-general
On Wed, 6 Jun 2001, John Scott wrote:

> well i wasn't interested in using oids in my application.
> i was curious about the relationship oids
> and the tuple/row limit.
>
> i guess if what you say is true, the oids are NOT used internally
> by postgres.  this seems odd.

> so, i guess my question still stands ... what happens when oids wrap?
> are oids nothing more than a sequence with an index,
> not used at all internally?

They are used for references between system tables.  That's why
you'll get intermittent failures on things like create statements after
rollover (system tables may have unique index on oid).
As far as I know the system doesn't do stuff with the oid on user rows.



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: PostgreSQL Replication Server?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: PostgreSQL Replication Server?