Re: How to enumerate foreign key constraints after migrating from 7.1.3? - Mailing list pgsql-general

From Forest Wilkinson
Subject Re: How to enumerate foreign key constraints after migrating from 7.1.3?
Date
Msg-id taneevcjl3r025o7sehvi5149pvs6tio4l@4ax.com
Whole thread Raw
In response to Re: How to enumerate foreign key constraints after migrating  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
>> 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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres performance comments from a MySQL user
Next
From: Tom Lane
Date:
Subject: Re: Performance of query (fwd)