Re: OID wraparound: summary and proposal

> > Based on the discussion so far, here is an attempt to flesh out the
> > details of what to do with OIDs for 7.2:
> > 
> > 1. Add an optional clause "WITH OIDS" or "WITHOUT OIDS" to CREATE TABLE.
> > The default behavior will be WITH OIDS.
> 
> What about having an additional Oid generator which solely serves for
> supplying user tables' per row Oids? It seems relatively easy to
> implement, comparing with 64-bit Oids or Oid-less tables. I assume
> that the Oid wraparound problem is not so serious with user tables.

This is a very interesting idea.  Have two oid counters, one for system
tables and another for user tables.  It isolates problems with oid
wraparound caused by large user tables.

--  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