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)
knownto 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