I can confirm that current CVS handles this OK. ---------------------------------------------------------------------------
Christopher Kings-Lynne wrote: > I had a suspicion and it was confirmed: > > test=# create table oidtest (a int4, unique(oid)); > NOTICE: CREATE TABLE / UNIQUE will create implicit index > "oidtest_oid_key" for table "oidtest" > CREATE TABLE > test=# select oid from oidtest; > oid > ----- > (0 rows) > > test=# alter table oidtest set without oids; > ALTER TABLE > test=# select oid from oidtest; > ERROR: column "oid" does not exist > test=# \d oidtest > ERROR: cache lookup failed for attribute -2 of relation 765798 > > > Chris > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]