Skip site navigation (1) Skip section navigation (2)

Re: BUG: mismatched parentheses

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Brendon Matthews <brendonm(at)bbtechltd(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG: mismatched parentheses
Date: 2002-06-03 06:44:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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

In response to

pgsql-bugs by date

Next:From: Rob ButlerDate: 2002-06-03 13:19:45
Subject: Re: PQescapeString and PQescapeBytea not exported during win 32 build
Previous:From: Bruce MomjianDate: 2002-06-02 22:38:02
Subject: Re: PQescapeString and PQescapeBytea not exported during win

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group