Josh Berkus wrote: > All, > > So, I'll ask again (because I didn't see a reply): is there any way > users can *check* if they've been corrupted? Short of waiting for PK/FK > violations?
Obviously there are queries you can run to check each FK -- the same queries that ri_triggers.c would run when you create an FK. It's cumbersome to write, but not impossible. In fact, it can be done mechanically. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers