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!
--
TIP 8: explain analyze es tu amigo
