Re: OID wraparound (was Re: pg_depend) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: OID wraparound (was Re: pg_depend)
Date
Msg-id 200107201420.f6KEKix08558@candle.pha.pa.us
Whole thread Raw
In response to Re: OID wraparound (was Re: pg_depend)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: OID wraparound (was Re: pg_depend)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Ability to create tables
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: OID wraparound (was Re: pg_depend)