Re: Tigger after delete with plpgsql - Mailing list pgsql-general

<meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">


    Hi,

    You're using a trigger AFTER, in your case could be BEFORE?
    Cause when you use AFTER the var OLD not exists...
    I don't know if I understand exactly what you'll do to ativate this
    trigger..
    but I think maybe is it..

    try..


    Em 31/08/2012 14:10, Fellipe Henrique escreveu:
    <blockquote
cite="mid:CAF1jwZH+cXLCwHwZCF53eBtXADm=u4B_+6kQqJA9GfmctJ=Zaw@mail.gmail.com"
      type="cite">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?


        Best Regards,




        T.·.F.·.A<span
          style="color:black">.·.     S+F
        Fellipe
              Henrique P. Soares<span
            style="font-size:7.5pt;color:rgb(102,102,102)" lang="EN-US">

        "Life
              is a game without Tutorial"
        <a
                moz-do-not-send="true" href="http://fellipeh.eti.br"
                target="_blank">http://fellipeh.eti.br