FOR EACH STATEMENT triggers
От | Neil Conway |
---|---|
Тема | FOR EACH STATEMENT triggers |
Дата | |
Msg-id | 87vg2zh772.fsf@mailbox.samurai.com обсуждение исходный текст |
Ответы |
Re: FOR EACH STATEMENT triggers
|
Список | pgsql-hackers |
I'd like to implement FOR EACH STATEMENT triggers. AFAICS it shouldn't be too tricky -- so if there's some show-stopper that prevented it from being done earlier, let me know now, please :-) Some random notes on the implementation I'm thinking of: - in the function called by a per-statement trigger, no references to the 'OLD' or 'NEW' rows will be allowed - should we allow per-statement BEFORE triggers? DB2 doesn't, but I'm not sure that's because they just cutcorners, or if there's some legitimate reason not to allow them. AFAICT SQL 200x doesn't specify thatthey *aren't* allowed, so I'm inclined to allow them... - if the statement effects zero rows, a per-statement trigger is still executed - COPY executes per-statement INSERT triggers, to stay consistent with the current behavior WRT per-row INSERT triggers - specifying 'FOR EACH xxx' in CREATE TRIGGER should now be optional; if neither is specified, FOR EACH STATEMENTis the default. This is per SQL spec (SQL 200x, 11.39, 8) Comments? Cheers, Neil -- Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
В списке pgsql-hackers по дате отправления: