On Tue, 28 May 2002, Brendon Matthews wrote:
> 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
In response to
pgsql-bugs by date
|Next:||From: Rob Butler||Date: 2002-06-03 13:19:45|
|Subject: Re: PQescapeString and PQescapeBytea not exported during win 32 build|
|Previous:||From: Bruce Momjian||Date: 2002-06-02 22:38:02|
|Subject: Re: PQescapeString and PQescapeBytea not exported during win|