| From: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | RI and restoring dumps |
| Date: | 2000-12-13 22:04:33 |
| Message-ID: | 00121317043321.00289@comptechnews |
| 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.
--
-------- Robert B. Easter reaster(at)comptechnews(dot)com ---------
- CompTechNews Message Board http://www.comptechnews.com/ -
- CompTechServ Tech Services http://www.comptechserv.com/ -
---------- http://www.comptechnews.com/~reaster/ ------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert B. Easter | 2000-12-13 22:30:49 | Re: RI and restoring dumps |
| Previous Message | Frank Joerdens | 2000-12-13 21:59:05 | Re: TOAST & performance with lots of big columns in a table |