Re: OIDS question

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: OIDS question
Date: 2008-08-02 11:39:16
Message-ID: 48944764.2010605@sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Tom Lane wrote:
> Frank Bax <fbax(at)sympatico(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Wm.A.Stafford 2008-08-04 19:40:20 pl/pgSQL development environment
Previous Message Tom Lane 2008-08-02 04:43:27 Re: OIDS question