From: | miguel <mvillagomez(at)sayab(dot)com(dot)mx> |
---|---|
To: | Juan Ramirez <juanrmiranda(at)hotmail(dot)com> |
Cc: | PostGreSQL Lista de Ayuda <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | RE: Pregunta sobre error en disparador |
Date: | 2008-11-15 16:11:20 |
Message-ID: | 1226765480.3059.30.camel@sayab-w03.sayab |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
El sáb, 15-11-2008 a las 14:13 -0100, Juan Ramirez escribió:
> > Subject: Re: [pgsql-es-ayuda] Pregunta sobre error en disparador
> > > ERROR: record "new" is not assigned yet
> > > SQL state: 55000
> > > Detail: The tuple structure of a not-yet-assigned record is
> > > indeterminate.
> > > Context: PL/pgSQL function "movement_trg" line 25 at if
> >
> > CREATE TRIGGER movement_trg
> > AFTER UPDATE OR DELETE
> > ON m_movement
> > FOR EACH ROW
> > EXECUTE PROCEDURE movement_trg();
> >
>
> por ahí leí que el NEW esta en el BEFORE no en el AFTER....
>
> la declaración de tu trigger esta mala, hacelo así;
>
> CREATE TRIGGER movement_trg
> BEFORE UPDATE OR DELETE
> ON m_movement
> FOR EACH ROW
> EXECUTE PROCEDURE movement_trg();
>
Gracias por la respuesta pero aun cambiando la declaración me sigue
marcando el error:
ERROR: record "new" is not assigned yet
DETAIL: The tuple structure of a not-yet-assigned record is
indeterminate.
CONTEXT: PL/pgSQL function "movement_trg" line 20 at if
STATEMENT: DELETE FROM M_Movement
WHERE M_Movement_ID
IN ('1000000') AND AD_Client_ID IN (1000000) AND AD_Org_ID IN
(1000000);
>
>
> ______________________________________________________________________
> Discover the new Windows Vista Learn more!
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Moreno | 2008-11-15 18:15:13 | Re: Pregunta sobre error en disparador |
Previous Message | Jenaro Centeno Gómez | 2008-11-15 15:47:15 | Re: Postgres en W. Vista |