From: | Konstantin Nikiforov <helllamer(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug: table inheritance. Trigger before DELETE for each statement is ignored |
Date: | 2010-12-02 20:23:43 |
Message-ID: | 20101202232343.02f9246c@alkaida |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Version: postgresql 9.0.1
Step to reproduce: use following code. It creates two tables (parent
"xtest" and inherited "xtest_inh"), creates trigger function, creates
BEFORE INSERT/UPDATE/DELETE trigger.
*************************************
CREATE TABLE xtest (id serial, data varchar, primary key(id));
CREATE TABLE xtest_inh (check (id > 0), primary key(id))
INHERITS (xtest);
-- insert some data to inherited table "xtest_inh"
INSERT INTO xtest_inh(data) values ('ddd'), ('lol'), ('olo');
-- this function just raises an exception every time
CREATE FUNCTION just_raise_exception_tg() returns trigger as $$
BEGIN
raise exception 'aaaaaaaaaaaaaaaaaaaaa!';
END; $$ language plpgsql;
-- adding STATEMENT-level trigger to inherited table "xtest_inh"
CREATE TRIGGER just_raise_exception_tg
BEFORE INSERT OR UPDATE OF data OR DELETE ON xtest_inh
FOR EACH STATEMENT execute procedure just_raise_exception_tg(2);
-- do some operations, that should cause to trigger the table
-- INSERT into xtest_inh(data) values ('omg');
DELETE from xtest where id = 2;
drop table xtest cascade;
drop function just_raise_exception_tg() cascade;
**********************************
Expected result: exception will be raised before deletion of rows is
done.
Real result: no exception occurs. One of rows is really deleted.
The trigger is ignored.
Comments:
1. You can uncomment INSERT statement, and try again: exception
will be thrown. BEFORE INSERT works, BEFORE delete - no.
2. If i create trigger FOR EACH STATEMENT, it will work ok for insert,
update and delete.
3. AFTER DELETE statement-level trigger also does not work at all.
bug?
From | Date | Subject | |
---|---|---|---|
Next Message | Jorge Augusto Meira | 2010-12-02 20:24:43 | Problems with max_connections parameter |
Previous Message | Grant Hutchins and Peter Jaros | 2010-12-02 15:44:29 | BUG #5781: unaccent() function should be marked IMMUTABLE |