Re: Proposal: More flexible backup/restore via pg_dump

Philip Warner <pjw@rhyme.com.au>

From: Philip Warner <pjw@rhyme.com.au>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-hackers@postgresql.org
Date: 2000-06-28T03:05:21Z
Lists: pgsql-hackers
At 13:10 27/06/00 -0700, Stephan Szabo wrote:
>
>Actually, there is an ALTER TABLE ADD CONSTRAINT for foreign key
>constraints.
>

This is good to know; presumably at some stage in the future the rest will
be added, and the backup/restore can be amended to apply constraints after
data load. In the mean time, I suppose people with tape drives who need to
reorder the data load will have to make multiple passes (or copy the file
locally).

 


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/