| From: | Juan Ramirez <juanrmiranda(at)hotmail(dot)com> |
|---|---|
| To: | <mvillagomez(at)sayab(dot)com(dot)mx> |
| Cc: | PostGreSQL Lista de Ayuda <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | RE: Pregunta sobre error en disparador |
| Date: | 2008-11-15 15:13:28 |
| Message-ID: | BAY104-W1556FF10B41DCE75E4524CD1110@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leonardo A. Marchese | 2008-11-15 15:27:20 | Postgres en W. Vista |
| Previous Message | Juan Ramirez | 2008-11-15 15:09:34 | RE: join - versus - exists [performance] |