Re: [GENERAL] Verifying Referential Integrity

2004-10-06 Thread Jimmie H. Apsey
Tom Lane wrote: "Geisler, Jim" <[EMAIL PROTECTED]> writes: So, as far as I know, PostgreSQL does not have any way of verifying the loss of referential integrity. What are you trying to accomplish here, and in what PG version? Are you trying to check that PG thinks that

Re: [GENERAL] Verifying Referential Integrity

2004-10-05 Thread Tom Lane
"Geisler, Jim" <[EMAIL PROTECTED]> writes: > So, as far as I know, PostgreSQL does not have any way of verifying the loss > of referential integrity. What are you trying to accomplish here, and in what PG version? Are you trying to check that PG thinks that a foreign-key relationship is installed

Re: [GENERAL] Verifying Referential Integrity

2004-10-05 Thread Frank Miles
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" solu

Re: [GENERAL] Verifying Referential Integrity

2004-10-05 Thread Jimmie H. Apsey
Geisler, Jim wrote: Message 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?   Of course, Tom Lane suggested I lo

Re: [GENERAL] Verifying Referential Integrity

2004-10-05 Thread Alvaro Herrera
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

[GENERAL] Verifying Referential Integrity

2004-10-05 Thread Geisler, Jim
Title: Message 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?