Re: RI and restoring dumps - Mailing list pgsql-general

From Joel Burton
Subject Re: RI and restoring dumps
Date
Msg-id 3A38E204.1515.CFA8A8@localhost
Whole thread Raw
In response to RI and restoring dumps  ("Robert B. Easter" <reaster@comptechnews.com>)
List pgsql-general
> Has anyone experienced referential integrity (RI) problems while
> restoring data from a dump?  Like, if the dump doesn't restore the
> data in the right order, then primary keys might not be in place
> before the foreign keys are restored.  I want to know this from people
> who have experience before I do use RI!
>
> Actually I did use RI in a database but had complications with it (I
> forget exactly what it was, something like the order of PL/SQL
> procedures and RI triggers firing caused some problems) but removed
> them all and just tried implementing all the checks I wanted in my
> PL/SQL triggers myself.

I never been unable to restore from a dump due to any RI problems.
I don't have a terribly complex db--about 100 tables, about 100 FK
relationships--but during development, it was dumped and restored
about 40 times.

(I have seen a dump that didn't restore having to do w/a VIEW that
output its definition in such a way that it couldn't be reCREATEd,
but, with a little help from a human, could be rewritten.)


--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)

pgsql-general by date:

Previous
From: "Zolof"
Date:
Subject: Working under NT
Next
From: "Joel Burton"
Date:
Subject: Re: [HACKERS] How to import/export data from/to an ASCII file?