Re: OIDS question - Mailing list pgsql-novice

From Frank Bax
Subject Re: OIDS question
Date
Msg-id 48944764.2010605@sympatico.ca
Whole thread Raw
In response to Re: OIDS question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tom Lane wrote:
> Frank Bax <fbax@sympatico.ca> writes:
>> While playing with this I noticed that using the -c -o options of
>> pg_dump together; I get OIDS in COPY statements, but not in the CREATE
>> commands.  Either this is a bug; or I'm missing something here...
>
> Please provide some details ... AFAICS the COPY and CREATE TABLE cases
> are testing the same conditions.



Never mind; I was missing something. It seems that pg_dump puts out SET
commands instead of using "WITH OIDS" option on "CREATE TABLE"; as in:

SET default_with_oids = true;
SET default_with_oids = false;

Sorry for the noise.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: OIDS question
Next
From: "Wm.A.Stafford"
Date:
Subject: pl/pgSQL development environment