Re: Regarding COPY command from Postgres 8.2.0 - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Regarding COPY command from Postgres 8.2.0
Date
Msg-id dcc563d10709180804q6655bdefna25a9b5a57089769@mail.gmail.com
Whole thread Raw
In response to Re: Regarding COPY command from Postgres 8.2.0  ("soni de" <soni.de@gmail.com>)
List pgsql-performance
On 9/17/07, soni de <soni.de@gmail.com> wrote:
> We have upgraded postgres from 7.2.4 to 8.2.0.
> We have program which executes COPY command and our new database is changed
> having some extra columns in some tables.
> Because of this, COPY commands are failing.
> So, we wanted the option to COPY the data without specifying column names.

Can't you just edit the import to have the newer 8.2.x syntax of

COPY table (field1, field2, field3, field4) FROM stdin;

???

And please tell me you aren't running 8.2.0, but 8.2.4 or now that it
just came out, 8.2.5.  Those minor point releases contain a lot of bug
fixes, and you're just asking for trouble by running a .0 release.

pgsql-performance by date:

Previous
From: "Evan Carroll"
Date:
Subject: Re: Regarding COPY command from Postgres 8.2.0
Next
From: "Dave Dutcher"
Date:
Subject: Re: Query works when kludged, but would prefer "best practice" solution