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