Re: Delete triggers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mathew Frank" <mathewfrank(at)qushi(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Delete triggers
Date: 2003-04-03 15:04:48
Message-ID: 28449.1049382288@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Mathew Frank" <mathewfrank(at)qushi(dot)com> writes:
> The documentation on this is very thin on the ground - I`ve just spend 4 Ho=
> urs googling and the best I could find was one of the main developers (Bruc=
> e?? sorry - too long ago) replying to an email in 2001. Which was to NOT=
> cancel the delete operation, you need to return NEW or OLD.

There is no NEW row in a delete trigger. RETURN OLD should work.

> - If I return OLD the operation is cancelled ("DELETE 0").

I suspect pilot error.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2003-04-03 15:50:23 Re: Bug #931: bugs "create user" "alter user"
Previous Message Tony Harper 2003-04-03 12:56:38 RelationBuildDesc Notice