Mismatched parentheses when creating a rule with multiple action queries - Mailing list pgsql-hackers

From Yurgis Baykshtis
Subject Mismatched parentheses when creating a rule with multiple action queries
Date
Msg-id 56510AAEF435D240958D1CE8C6B1770A0138A589@mailc03.aurigin.com
Whole thread Raw
List pgsql-hackers
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...  );





pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SIGSEGV on cvs tip/7.3.2
Next
From: Hans-Jürgen Schönig
Date:
Subject: Re: DATA-CUBE in Postgresql.