| 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: | Whole Thread | Raw Message | 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.
| 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 |