Re: COPY commands could use an enhancement. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: COPY commands could use an enhancement.
Date
Msg-id 1431.988682778@sss.pgh.pa.us
Whole thread Raw
In response to Re: COPY commands could use an enhancement.  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
Philip Warner <pjw@rhyme.com.au> writes:
> Do you have a alternate suggestion as to how to solve the problems it has
> backing up the regression DB?

One possibility is to fix ALTER TABLE ADD COLUMN to maintain the same
column ordering in parents and children.

COPY with specified columns may in fact be the best way to deal with
that particular issue, if pg_dump is all we care about fixing.  However
there are a bunch of things that have a problem with it, not only
pg_dump.  See thread over in committers about functions and inheritance.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: date conversion (was Re: Re: v7.1.1 branched and released on Tuesday ...)
Next
From: The Hermit Hacker
Date:
Subject: Re: v7.1.1 branched and released on Tuesday ...