Re: RI and restoring dumps

From: "Joel Burton" <jburton(at)scw(dot)org>
To: "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: RI and restoring dumps
Date: 2000-12-14 20:06:44
Message-ID: 3A38E204.1515.CFA8A8@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)scw(dot)org
Support Center of Washington (www.scw.org)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joel Burton 2000-12-14 20:14:48 Re: [HACKERS] How to import/export data from/to an ASCII file?
Previous Message Peter Eisentraut 2000-12-14 16:38:23 Re: Problem with pg_hba.conf