(FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions
От
Richard Broersma Jr
Тема
(FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions
Дата
Msg-id
20060829231449.71556.qmail@web31807.mail.mud.yahoo.com
Список
Дерево обсуждения
(FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions Richard Broersma Jr <rabroersma@yahoo.com>
Re: (FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions Michael Fuhr <mike@fuhr.org>
My question is:
In PostgreSQL, is it possible for a trigger function called by a STATEMENT LEVEL AFTER {any}
TRIGGER to roll back or commit an implied transaction of a single SQL Statement?
Here is the Context:
While reading "SQL For Smarties", I came across a pseudo code trigger function:
CREATE TRIGGER CheckManagers
AFTER UPDATE ON JobAsignments -- same for INSERT
IF 1 <= ALL (SELECT COUNT(*)
FROM JobAssignments
WHERE job_type = 99
GROUP BY store_nbr)
THEN ROLLBACK;
ELSE COMMIT;
END IF;
The intent is to rollback any changes made to a table that violate certain design constraints.
This trigger was intended as a work around for RDBMS that have not yet implemented ASSERTIONS.
Regards,
Richard Broersma Jr.
В списке pgsql-novice по дате отправления