| From: | Frank Miles <fpm(at)u(dot)washington(dot)edu> |
|---|---|
| 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:57:56 |
| Message-ID: | Pine.A41.4.61.0410051153220.192884@homer09.u.washington.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 5 Oct 2004, Geisler, Jim wrote:
> So, as far as I know, PostgreSQL does not have any way of verifying the loss
> of referential integrity.
>
> Are there any recommended methods or utilities for checking referential
> integrity in a PostgreSQL database?
Perhaps someone knows of a more "automatic" solution, but what I have done
is generate a test set that exercises as many aspects of the table design
as I have been able to imagine. It also tests pgsql functions, including
triggers. This is particularly useful with version changes. As the
occasional bug is found, more test cases are added. Like a unit or
regression test, of course.
Those more experienced than I probably have better ideas...
-frank
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2004-10-05 20:10:49 | Re: Postgres 8.0 + JDBC |
| Previous Message | Jimmie H. Apsey | 2004-10-05 18:24:17 | Re: Verifying Referential Integrity |