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

Поиск
Список
Период
Сортировка
От Forest Wilkinson
Тема Re: How to enumerate foreign key constraints after migrating from 7.1.3?
Дата
Msg-id taneevcjl3r025o7sehvi5149pvs6tio4l@4ax.com
обсуждение исходный текст
Ответ на Re: How to enumerate foreign key constraints after migrating  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres performance comments from a MySQL user
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance of query (fwd)