Re: OID wraparound: summary and proposal - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: OID wraparound: summary and proposal
Date
Msg-id 3B68A5A6.4AFB7C6F@tpf.co.jp
Whole thread Raw
In response to OID wraparound: summary and proposal  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > Tom Lane wrote:
> >>
> >> Given Hiroshi's objections, and the likelihood of compatibility problems
> >> for existing applications, I am now thinking that it's not a good idea to
> >> turn off OID generation by default.
> 
> > Would OIDs be globally unique or per table ?
> 
> Same as now: if you have a unique index on 'em, they're unique within a
> table; otherwise, no guarantee at all (once the system wraps around).
> 

OIDs per table seems more important than others.

Strangely enough, I've seen no objection to optional OIDs
other than mine. Probably it was my mistake to have formulated
a plan on the flimsy assumption. 

regards,
Hiroshi Inoue


pgsql-hackers by date:

Previous
From: Mike Mascari
Date:
Subject: Re: Is there a way to drop and restore an index?
Next
From: Tom Lane
Date:
Subject: Re: OID wraparound: summary and proposal