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 16360.1080023757@sss.pgh.pa.us
Whole thread Raw
In response to bug in 7.4 SET WITHOUT OIDs  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: bug in 7.4 SET WITHOUT OIDs  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> I had a suspicion and it was confirmed:
> test=# create table oidtest (a int4, unique(oid));

The problem appears to be that ALTER TABLE SET WITHOUT OIDS doesn't make
the index on the OID column go away.

I don't have a strong opinion on whether to fix this by forcing a drop
of the index or by rejecting the ALTER command.  Seems like we have to
do one or the other though.

This is actually just the simplest case of a dependency on the OID
column... whatever the fix is, it has to handle the general case.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: pg_autovacuum
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: bug in 7.4 SET WITHOUT OIDs