[HACKERS] Mismatched parentheses when creating a rule with multiple action queries

[Yurgis Baykshtis]

PostgreSQL 7.3.2.
The parser does not seem to like semicolon between action queries:
(Mismatched parentheses)

Advertising

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... 
  );




---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html