> Unfortunately there's no very simple way to determine which FK is the
> problem. (In 8.1 it'll be possible to do that with EXPLAIN ANALYZE,
> but in existing releases EXPLAIN doesn't break out the time spent in
> each trigger ...) You have to just eyeball the schema :-(.
phpPgAdmin has a handy info feature where you can see all tables that
refer to the current one. You can always go and steal that query to
find them...
Chris