Re: OID wraparound: summary and proposal

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: OID wraparound: summary and proposal
Date: 2001-08-07 08:24:12
Message-ID: 20010807172412A.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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.
--
Tatsuo Ishii

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-08-07 10:13:29 Re: failed: make install prefix=/foo/bar
Previous Message Matthew Kirkwood 2001-08-07 07:17:56 Re: Notes about int8 sequences