Mismatched parentheses when creating a rule with multiple action queries

From: "Yurgis Baykshtis" <ybaykshtis(at)aurigin(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Mismatched parentheses when creating a rule with multiple action queries
Date: 2003-05-28 20:06:35
Message-ID: 56510AAEF435D240958D1CE8C6B1770A0138A589@mailc03.aurigin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...
);

Browse pgsql-hackers by date

  From Date Subject
Next Message John DeSoi 2003-05-28 20:22:15 3.0 fe/be protocol bug?
Previous Message Tom Lane 2003-05-28 18:38:50 Re: SIGSEGV on cvs tip/7.3.2