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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
