Re: Verifying Referential Integrity

"Geisler, Jim" <jgeisler(at)vocollect(dot)com> 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? In recent versions psql's "\d" will tell you that. If
you're dealing with an old version you might have to look directly at
the system catalogs.

Are you not trusting that an active foreign-key relationship has been
correctly enforced? Then I think you want to do some kind of JOIN
query to see if you can find any rows with no master row. (You could
actually do this by temporarily creating a new, redundant FK constraint;
but if you are feeling that paranoid you're likely not going to trust
the system's answer anyway...)

regards, tom lane