Re: Determin if cascade is being used

Martin Foster <martin(at)ethereal-realms(dot)org> writes:
> 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 sounds like you're trying to do manual enforcement of a foreign key
relationship. Wouldn't it be better to let the standard FK mechanism
handle it for you?

(But the short answer is no, I don't think you can tell that from
plpgsql, or even very reasonably from a C trigger.)

regards, tom lane