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

2003-05-29 Thread Tom Lane
"Yurgis Baykshtis" <[EMAIL PROTECTED]> writes: > The problem happens only when running this query from the plpgsql > function... So it must be a bug specific to plpgsql parser. It's actually plpgsql trying to be helpful and detect errors. 99% of the time I think this behavior would be considered

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

2003-05-29 Thread Yurgis Baykshtis
The problem happens only when running this query from the plpgsql function... So it must be a bug specific to plpgsql parser. -Original Message- From: Yurgis Baykshtis Sent: Wednesday, May 28, 2003 1:07 PM To: [EMAIL PROTECTED] Subject: Mismatched parentheses when creating a rule with mu

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

2003-05-29 Thread Yurgis Baykshtis
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 IN