Re: A bug in triggers PG 7.1.3 or misunderstand ?
Domingo Alvarez Duarte <domingo@dad-it.com>
From: domingo@dad-it.com (Domingo Alvarez Duarte)
To: pgsql-sql@postgresql.org
Date: 2001-09-28T08:28:25Z
Lists: pgsql-sql
tgl@sss.pgh.pa.us (Tom Lane) wrote in message news:<28856.1001608373@sss.pgh.pa.us>... > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html Ok I saw that in the documentation so I tryied a variant of it: if TG_OP = 'DELETE' then return old; else return new; end if; But the TG_OP comes empty and it allawys try return new preventing the delete to happen. And that was supposed to work isn't it ?