Determin if cascade is being used - Mailing list pgsql-novice

From Martin Foster
Subject Determin if cascade is being used
Date
Msg-id 4353D0D0.6090808@ethereal-realms.org
Whole thread Raw
Responses Re: Determin if cascade is being used  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Switching from MySQL -- Missing DESCRIBE table, SHOW
Next
From: Tom Lane
Date:
Subject: Re: Determin if cascade is being used