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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Yurgis Baykshtis" <ybaykshtis(at)aurigin(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Mismatched parentheses when creating a rule with multiple action queries
Date: 2003-05-28 23:55:11
Message-ID: 9278.1054166111@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Yurgis Baykshtis" <ybaykshtis(at)aurigin(dot)com> 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 a feature
rather than a bug --- issuing CREATE RULE from a plpgsql function is
well out past the second standard deviation (even with only one action
in it ;-)), and AFAIK there are no other cases where a semicolon could
be embedded in a SQL construct. So I'm inclined to leave it as-is.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-05-28 23:56:33 Re: 3.0 fe/be protocol bug?
Previous Message Tom Lane 2003-05-28 23:20:14 Re: Automatic detection of client encoding