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