Postgres Pro
Downloads
Home   >   mailing lists

Re: A bug in triggers PG 7.1.3 or misunderstand ? - Mailing list pgsql-sql

From Tom Lane
Subject Re: A bug in triggers PG 7.1.3 or misunderstand ?
Date
Msg-id 28856.1001608373@sss.pgh.pa.us
Whole thread Raw
In response to A bug in triggers PG 7.1.3 or misunderstand ?  (domingo@dad-it.com (Domingo Alvarez Duarte))
List pgsql-sql
Tree view 
I think you need "return old", not "return new", in the body of the
trigger if you want the delete to take place.  new would be NULL in
a delete situation ...
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: PARSER ERROR persists ....
Next
From: Tom Lane
Date:
Subject: Re: Aggregate Aggravation