PostgreSQL 7.3.2.
The parser does not seem to like semicolon between action queries:
(Mismatched parentheses)
So, it makes impossible to create a rule with more than one action
query.
Or am I missing something?
CREATE RULE my_insert_rule AS ON INSERT TO my_view DO INSTEAD ( INSERT INTO my_table1... ; INSERT INTO
my_table2...);
The rule with just one action works fine: DO INSTEAD ( INSERT INTO my_table1... );