Determin if cascade is being used

Поиск
Список
Период
Сортировка
От Martin Foster
Тема Determin if cascade is being used
Дата
Msg-id 4353D0D0.6090808@ethereal-realms.org
обсуждение исходный текст
Ответы Re: Determin if cascade is being used  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Is there a way to tell in PL/PgSQL if the delete coming down the line is
from a cascade delete?   I have a trigger, which when called will throw
an error because the row its trying to change is now linked with an item
which no longer exists.   The foreign key constraint fails since it was
removed before underlaying components were.

This would also greatly speed up the trigger since it could skip any
updates at all!   Thanks in advance.


    Martin Foster
    martin@ethereal-realms.org


В списке pgsql-novice по дате отправления:

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: Switching from MySQL -- Missing DESCRIBE table, SHOW
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Determin if cascade is being used