Transactions in rules.. - Mailing list pgsql-general

Can i use transactions in rules??
I was trying something like:

create rule x_test as
on insert to view1
do instead
(
    begin;
    insert into test1 values (new.a,new.b);
    insert into test2 values (new.c,new.d);
    commit;
);

But when i give this command in psql i always get an error..

Regards

fabrizio@macrongolf.com
http://macrongolf.com
http://eteampoint.com
http://macron.com