Re: Proposal: More flexible backup/restore via pg_dump

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposal: More flexible backup/restore via pg_dump
Date: 2000-06-28 03:05:21
Message-ID: 3.0.5.32.20000628130521.0241ba70@mail.rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 |/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2000-06-28 03:10:39 Re: AW: Proposal: More flexible backup/restore via pg_dump
Previous Message The Hermit Hacker 2000-06-28 01:18:54 Re: Mailing List Archive Problem?