Re: How to enumerate foreign key constraints after migrating from 7.1.3?

From: Forest Wilkinson <lyris-pg(at)tibit(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to enumerate foreign key constraints after migrating from 7.1.3?
Date: 2003-06-11 16:52:48
Message-ID: taneevcjl3r025o7sehvi5149pvs6tio4l@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-11 16:55:11 Re: Performance of query (fwd)
Previous Message Tom Lane 2003-06-11 16:49:09 Re: Postgres performance comments from a MySQL user

Browse pgsql-hackers by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2003-06-11 17:14:06 Re: Pre-allocation of shared memory ...
Previous Message Tom Lane 2003-06-11 16:37:46 Re: Function returns composite type