> 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(); _________________________________________________________________ Discover the new Windows Vista http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
