Re: Wacky OID idea

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Neil Conway" <nconway(at)klamath(dot)dyndns(dot)org>, "Alvaro Herrera" <alvherre(at)atentus(dot)com>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Wacky OID idea
Date: 2002-08-05 07:36:19
Message-ID: GNELIHDDFBOCMGBFGEFOKEICCDAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I don't think it would be easy to do this without rewriting the table,
> as Alvaro suggested. And if you're going to give this DROP COLUMN
> variant totally different behavior from any other form of DROP COLUMN,
> ISTM that it doesn't belong with DROP COLUMN.

Especially if we start saving the 4 bytes that a NULL oid takes up in a
table tuple on disk.

Perhaps:

ALTER TABLE tab SET WITHOUT OIDS;

I think the reverse operation would really be impossible...? Unless we run
through the entire table and insert an oid for each row from the oid
counter?

> That said, being able to remove the OIDs from a table would be fairly
> useful, IMHO.

Hell yeah.

By the way - I'm not saying I'll be implementing this any time soon!

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Sherry 2002-08-05 09:10:22 Re: Error: missing chunk number ...
Previous Message Neil Conway 2002-08-05 07:27:15 Re: Wacky OID idea