Postgres Pro
Downloads
Home   >   mailing lists

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 10330.1080099967@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  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> What I meant is - does it handle dropping a non-system 'oid' column? 
> ie. A user column that just happens to be named 'oid'.

If you have one (implying that you don't have a system OID column) then
"DROP COLUMN oid" will drop it, but "SET WITHOUT OIDS" will not.  Okay
with you?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PANIC: hash table "Shared Buffer Lookup Table" corrupted
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: bug in 7.4 SET WITHOUT OIDs