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.
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 |
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 |