Re: bug in 7.4 SET WITHOUT OIDs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: bug in 7.4 SET WITHOUT OIDs
Date
Msg-id 10081.1080099017@sss.pgh.pa.us
Whole thread Raw
In response to Re: bug in 7.4 SET WITHOUT OIDs  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: bug in 7.4 SET WITHOUT OIDs
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> I am currently testing a fix that allows you to say
>> ALTER TABLE DROP COLUMN oid;
>> which will behave the same way a regular user-column DROP would.

> Will it handle this case:
> usa=# create table testy (a int4) without oids;
> usa=# alter table testy add oid int4;

No.  This is DROP not ADD.

> How about the syntax:
> ALTER TABLE t DROP OIDS;

Why?  We already have one nonstandard-and-redundant syntax for this,
we surely do not need another.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: dollar quoting and pg_dump
Next
From: Tom Lane
Date:
Subject: Re: linked list rewrite