| 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: | Whole Thread | Raw Message | 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 |