BUG: mismatched parentheses

On Tue, 28 May 2002, Brendon Matthews wrote:

Hi,

I have found a bug in PostgreSQL 7.2.1.

I am trying to use plpgsql to run a simple INSERT on a table, and it always
comes up with an error saying "mismatched parentheses"

I firstly store the SQL in a TEXT variable:
a_sql := ''INSERT INTO mytable(theid,thenumber) VALUES(1,2);'';

Then i run the EXECUTE command in plpgsql:
EXECUTE a_sql;

I have tried many different ways to get the INSERT working, but all have
failed with the same result, however when i try to run the same INSERT
outside of plpgsql it always succeeds.

This problem is very serious, and needs to be sorted out.

Can you give a complete test case as a script that illustrates the
problem?