Re: Adding "on delete cascade" after table creation ?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Peter Alberer <h9351252(at)obelix(dot)wu-wien(dot)ac(dot)at>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Adding "on delete cascade" after table creation ?
Date: 2002-09-26 14:15:57
Message-ID: 20020926071349.L23362-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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>")

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-09-26 14:33:58 Re: Performance while loading data and indexing
Previous Message Manfred Koizar 2002-09-26 14:14:10 Re: Nicer dump files?