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

From Bruce Momjian
Subject Re: bug in 7.4 SET WITHOUT OIDs
Date
Msg-id 200406090132.i591Wpr04808@candle.pha.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
List pgsql-hackers
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 pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Frequently updated tables
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: bug in 7.4 SET WITHOUT OIDs