Re: Tigger after delete with plpgsql

On Friday, August 31, 2012 02:10:47 PM Fellipe Henrique wrote:
> Hello, I`m try to use this code for my After Delete trigger:
>
> delete
> from MOVIMENTO
> where (IDEMPRESA = OLD.idempresa) and
> (upper(TABELA) = 'NFENTRADA_ITEM') and
> (CODIGO = OLD.idempresa_item);
>
> But, when execute. show me error.. that`s says
>
> "old is not initialize" (sorry,but I dont know how exactly error msy
> because in my SO, give in portuguese)..
>
> my question is: how can I use OLd and NEW in posgre?
>

Just like that. Which implies something else is wrong. Please post the whole
trigger function and a \d of the table where this trigger is used, and the SQL
that you are executing that results in the error.