"Peter Alberer" <h9351252@obelix.wu-wien.ac.at> writes:
> From looking at the techdocs document i got the impression that I simply
> need to change the value of "tgfoid" in pg_trigger from "1654"
> (RI_FKey_noaction_del) to "1646" (RI_FKey_cascade_del). Is this correct?
Probably, but also keep an eye on the tgtype and tgargs. I'd recommend
creating two dummy tables with the right kind of foreign-key constraint,
and then looking at how their triggers are configured.
regards, tom lane