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? ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
