Re: ON DELETE trigger blocks delete from my table

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Naeem Bari <naeem(dot)bari(at)agilissystems(dot)com>
Cc: Jan Wieck <JanWieck(at)Yahoo(dot)com>, Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar>, pgsql-general(at)postgresql(dot)org
Subject: Re: ON DELETE trigger blocks delete from my table
Date: 2004-10-25 21:58:59
Message-ID: 1098741539.10951.82.camel@linda
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2004-10-25 at 15:09 -0500, Naeem Bari wrote:
> Ok, a really newbie question - I think I will switch to using "after"
> rather than "before" - but can I modify the trigger statement without
> dropping the trigger function?

CREATE OR REPLACE FUNCTION ...

--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"Only take heed to thyself, and keep thy soul
diligently, lest thou forget the things which thine
eyes have seen, and lest they depart from thy heart
all the days of thy life; but teach them to thy sons,
and to thy sons' sons..." Deuteronomy 4:9

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ruben 2004-10-25 22:28:49 pg_restore does not restore
Previous Message CSN 2004-10-25 21:56:34 Re: copy - fields enclosed by, ignore x lines