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

From Stephan Szabo
Subject Re: Adding "on delete cascade" after table creation ?
Date
Msg-id 20020926071349.L23362-100000@megazone23.bigpanda.com
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
On Thu, 26 Sep 2002, Peter Alberer wrote:

> 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?

Technically, yes I believe so (well, check to make sure the oids are those
values on your system). I usually don't suggest manual surgery to the
system tables as messing up is somewhat painful (even in dropping the
triggers I'd suggest using drop trigger "<name>")


pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: Nicer dump files?
Next
From: Tom Lane
Date:
Subject: Re: Performance while loading data and indexing