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(i
Also another bug and usecase connected with subj.
It creates parent table "xtest", inherited table "xtest_inh" with
some data, and a trigger BEFORE INSERT/UPDATE/DELETE on table "xtest".
After, it deletes one row.
**
CREATE TABLE xtest (id serial, data varchar, prim
Ok, thanks, roger you.
But one question still cause my misunderstanding:
> > 2. If i create trigger FOR EACH STATEMENT, it will work ok for
> > insert, update and delete.
>
> You mean FOR EACH ROW, no?
Yes, confused. FOR EACH ROW.
"FOR EACH ROW"-trigger successfully fires in inherited
table "xte
