Re: OID wraparound (was Re: pg_depend)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: OID wraparound (was Re: pg_depend)
Дата
Msg-id 200107201420.f6KEKix08558@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>)
Список pgsql-hackers
Tom mentioned what should be stored in the OID system column if no oid's
are in the table.  He also mentioned that he doesn't want a
variable-length tuple header so will always have an oid system column.

What about moving the oid column out of the tuple header.  This saves 4
bytes in the header in cases where there is no oid on the table.

If they ask for an OID in a table, make it the first column of a table. 
Also, if they have asked for oid's on the table, odds are they want
SELECT * to show it.

Also, how about a GUC option that controls whether tables are created
with OID's by default.

--  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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Ability to create tables
Следующее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: OID wraparound (was Re: pg_depend)