| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | "Geisler, Jim" <jgeisler(at)vocollect(dot)com> |
| Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Verifying Referential Integrity |
| Date: | 2004-10-05 18:14:41 |
| Message-ID: | 20041005181441.GB4739@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Oct 05, 2004 at 02:03:09PM -0400, Geisler, Jim wrote:
> So, as far as I know, PostgreSQL does not have any way of verifying the loss
> of referential integrity.
... just like it doesn't have a way of verifying loss of tables or any
other object. If someone messes up the schema (be it via ALTER commands
or directly modifying system catalogs), Postgres will continue working
with the new schema.
> Are there any recommended methods or utilities for checking referential
> integrity in a PostgreSQL database?
Maybe do pg_dump -s periodically and compare to a known good version?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Si no sabes adonde vas, es muy probable que acabes en otra parte.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jimmie H. Apsey | 2004-10-05 18:24:17 | Re: Verifying Referential Integrity |
| Previous Message | Geisler, Jim | 2004-10-05 18:03:09 | Verifying Referential Integrity |