Horton
Menu

Re: pg_dump: Sorted output, referential integrity

Jan Wieck <janwieck@yahoo.com>

View thread
From: Jan Wieck <janwieck@yahoo.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Jan Wieck <janwieck@yahoo.com>, 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-12T23:19:11Z
Lists: pgsql-hackers 
Peter Eisentraut wrote:
> 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?

    The  data  came  (in  theory!!!)  from  an intact, consistent
    database.  So the dump content is (theoretically) known to be
    consistent, thus no check required.

    The  difference  between  theory and practice? There is none,
    theoretically :-)


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com