On Fri, 8 Mar 2002, [iso-8859-1] John Bell wrote:
> Can anyone tell me where the ON DELETE <action> and ON
> UPDATE <action> rules for foreign keys are stored in
> the system tables. I would have expected to find them
> in one of the relevent pg_trigger entries (ie. one
> with a tgtype of 9, 17 or 21). However there is no
> difference in these entries regardless of the value of
> <action>. I have also scoured other system tables to
> no avail.
It's based on the function called by the trigger (tgfoid).