Horton
Menu

Re: pg_dump: Sorted output, referential integrity

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Jan Wieck <janwieck@yahoo.com>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>, Philip Warner <pjw@rhyme.com.au>, Christof Petig <christof@petig-baender.de>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2001-12-12T22:25:21Z
Lists: pgsql-hackers 
Jan Wieck writes:

>     We don't want to define  the  constraints  with  ALTER  TABLE
>     because this means checking data on restore that doesn't need
>     to be checked at all (in theory).  If he has  a  crash  of  a
>     critical system and restores from a dump, I bet the farm that
>     he wants it FAST.

Um, if he has a *crash* of a *critical* system, doesn't he want his data
checked before he puts it back online?

-- 
Peter Eisentraut   peter_e@gmx.net