Re: OID wraparound (was Re: pg_depend)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: OID wraparound (was Re: pg_depend)
Дата
Msg-id 200107182008.f6IK8W900474@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: OID wraparound (was Re: pg_depend)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: OID wraparound (was Re: pg_depend)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: OID wraparound (was Re: pg_depend)  (Horst Herb <horst@hherb.com>)
Список pgsql-hackers
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Is the idea to make oid's optional, with them disabled by default on
> > user tables?
> 
> My thought is to make OID generation optional on a per-table basis, and
> disable it on system tables that don't need unique OIDs.  (OID would
> read as NULL on any row for which an OID wasn't generated.)
> 
> It remains to be debated exactly how users should control the choice for
> user tables, and which choice ought to be the default.  I don't have a
> strong opinion about that either way, and am prepared to hear
> suggestions.

I think it should be off on user tables by default, but kept on system
tables just for completeness.  It could be added at table creation time
or from ALTER TABLEL ADD.  It seems we just use them too much for system
stuff.  pg_description is just one example.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: Michael Widenius
Дата:
Сообщение: Re: MySQL Gemini code
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: OID wraparound (was Re: pg_depend)