Re: Postgres Triggers issue
От | Andreas Kretschmer |
---|---|
Тема | Re: Postgres Triggers issue |
Дата | |
Msg-id | 20100211172433.GA8135@tux обсуждение исходный текст |
Ответ на | Re: Postgres Triggers issue ("A. Kretschmer" <andreas.kretschmer@schollglas.com>) |
Ответы |
Re: Postgres Triggers issue
|
Список | pgsql-general |
A. Kretschmer <andreas.kretschmer@schollglas.com> wrote: > In response to Igor Neyman : > > > > > > CREATE TRIGGER tafter > > > AFTER INSERT OR UPDATE > > > ON r.m_a > > > FOR EACH ROW > > > EXECUTE PROCEDURE r.m_t(); > > > > > > > > > > Trigger function for an insert/update trigger should return "NEW", not > > NULL (OLD - for "on delete" trigger): > > It's an AFTER TRIGGER, so the RETURN-Value ignored. According the doc: The return value of a BEFORE or AFTER statement-level trigger or an AFTER row-level trigger is always ignored; it might as well be null. http://www.postgresql.org/docs/current/static/plpgsql-trigger.html Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-general по дате отправления: