Re: Adding "on delete cascade" after table creation ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Adding "on delete cascade" after table creation ?
Date
Msg-id 4063.1033051578@sss.pgh.pa.us
Whole thread Raw
In response to Re: Adding "on delete cascade" after table creation ?  ("Peter Alberer" <h9351252@obelix.wu-wien.ac.at>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: rotatelog / logrotate with PostgreSQL
Next
From: Ericson Smith
Date:
Subject: Unixtime (epoch) into timestamp?