Re: AW: OID wraparound: summary and proposal

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: AW: OID wraparound: summary and proposal
Дата
Msg-id 3B6A0246.3EC9EE7F@tpf.co.jp
обсуждение исходный текст
Ответ на AW: OID wraparound: summary and proposal  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Ответы Re: AW: OID wraparound: summary and proposal  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> 
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > Hmm there seems to be an assumption that people could
> > know whether they need OID or not for each table.
> 
> A good point, and one reason not to make no-OIDs the default.  I'm
> envisioning that people will turn off OIDs only for tables that they
> know will be very large and that they know they don't need OIDs for.
>

AFAIK few people have voted *OIDs by default* in the
first place. It seems to mean that *default* would
naturally(essentially) be changed to *WITH NO OIDS*.
The followings are the result of vote which I remember
well.

regards,
Hiroshi Inoue

"Mikheev, Vadim" wrote:
> 
> > OK, we need to vote on whether Oid's are optional,
> > and whether we can have them not created by default.
> 
> Optional OIDs:      YES
> No OIDs by default: YES

Lamar Owen wrote:
> 
> [trimmed cc:list]
> On Wednesday 18 July 2001 17:09, Bruce Momjian wrote:
> > OK, we need to vote on whether Oid's are optional, and whether we can
> > have them not created by default.
> 
> [All the below IMHO]
> 
> OID's should be optional.
> 
> System tables that absolutely have to have OIDs may keep them.
> 
> No new OID usage, period.  Use some other unique primary key.
> 
> Default user tables to no OIDs.


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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: TRUNCATE question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: patch for contrib/intarray (current CVS)