| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
| Cc: | Alfred Perlstein <bright(at)wintelcom(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: COPY commands could use an enhancement. |
| Date: | 2001-05-01 02:06:18 |
| Message-ID: | 1431.988682778@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Philip Warner <pjw(at)rhyme(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2001-05-01 02:12:56 | Re: v7.1.1 branched and released on Tuesday ... |
| Previous Message | Philip Warner | 2001-05-01 01:31:48 | Re: COPY commands could use an enhancement. |