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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
