Re: How to enumerate foreign key constraints after migrating from 7.1.3?
Forest Wilkinson <lyris-pg@tibit.com>
From: Forest Wilkinson <lyris-pg@tibit.com>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-general@postgresql.org
Date: 2003-06-11T16:52:48Z
Lists: pgsql-hackers
>> Okay, more questions: >> I see that adddepend detects old-style foreign key constraints by >> looking for groups of 3 triggers having 6 or more identical function >> arguments. Is that the best way to do it? It occurs to me that an >> alternative might be to find triggers that call RI_FKey_check_ins() >> and have the tgisconstraint flag set. Will either approach be safe in >> postgres 7.4? Perhaps a combination of the two would be best? > >Without looking at the other triggers, you can't determine the referential >action information since that's encoded in the functions the other two >triggers call. I understand that. I just want a list of the foreign key constraints that are set on the columns of a table. I don't really need to know what happens when a referenced column gets modified.