From: Tom Lane <tgl@sss.pgh.pa.us>
To: aklaver@attbi.com
Cc: Kathrine S <skybert_ks@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: ERROR: Invalid regular expression: parentheses ( ) not balanced
Date: Wed, 25 Aug 2004 22:54:28 -0400
Message-ID: <11496.1093488868@sss.pgh.pa.us> (raw)
In-Reply-To: <200408251944.52693.aklaver@comcast.net>
References: <cP6Wc.40160$Vf.2070014@news000.worldonline.dk>
<11200.1093486890@sss.pgh.pa.us>
<200408251944.52693.aklaver@comcast.net>
Adrian Klaver <aklaver@comcast.net> writes:
> I don't know what to make of it but the problem seems to start at the lines I
> have marked 1 & 2 and involves the lo_import function. I have not used
> lo_import and so do not know how to call it. What I do see is that it is
> called at 1 and a '(' shows up to the left of the prompt at 2 and stays
> there indicating to me at least the parser is not happy.
No, that's just because psql has noticed that the left paren following
VALUES is unmatched. I suppose that what Kathrine is showing us is
line-wrapped text and that the lo_import function call was actually
typed on the same line as "values(...", since there's not another psql
prompt visible there.
But in any case, the given error message could only have come from a
regex match operator (~ or ~*) that does not like the pattern operand it
was given. Since there's no ~ operator in the given query, I have to
suppose that the problem is in something that's being invoked behind-the-
scenes, like a trigger or rule.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, aklaver@attbi.com, skybert_ks@hotmail.com
Subject: Re: ERROR: Invalid regular expression: parentheses ( ) not balanced
In-Reply-To: <11496.1093488868@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox