Thread: ERROR: Invalid regular expression: parentheses ( ) not balanced

ERROR: Invalid regular expression: parentheses ( ) not balanced

From
"Kathrine S"
Date:
Below is a copy of my sql sentence including the error I am getting. What
does the error mean? What have I done wrong?

kathrirs=# insert into faglaerer
kathrirs-# values ('f-001', '13056802876', 'Petter L�r',
lo_import('/home/studenter/it03/kathrirs/img/img01.jpg'),
kathrirs(# '2001-12-25', 100, 'Professor', 'A', 1,
'{"linux","programmering","matematikk","neutrale nettverk"}',
kathrirs(# 12, 'petter.laer@dih.no', '8212');
ERROR:  Invalid regular expression: parentheses ( ) not balanced





Re: ERROR: Invalid regular expression: parentheses ( ) not balanced

From
Tom Lane
Date:
"Kathrine S" <skybert_ks@hotmail.com> writes:
> Below is a copy of my sql sentence including the error I am getting. What
> does the error mean? What have I done wrong?

> kathrirs=# insert into faglaerer
> kathrirs-# values ('f-001', '13056802876', 'Petter L�r',
> lo_import('/home/studenter/it03/kathrirs/img/img01.jpg'),
> kathrirs(# '2001-12-25', 100, 'Professor', 'A', 1,
> '{"linux","programmering","matematikk","neutrale nettverk"}',
> kathrirs(# 12, 'petter.laer@dih.no', '8212');
> ERROR:  Invalid regular expression: parentheses ( ) not balanced

There's no regular expression in what you've shown us.  Maybe you have
rules or triggers that are fired by this INSERT?  If so, you need to
look at what they are doing.
        regards, tom lane


Re: ERROR: Invalid regular expression: parentheses ( ) not balanced

From
Adrian Klaver
Date:
On Wednesday 25 August 2004 07:21 pm, Tom Lane wrote:
> "Kathrine S" <skybert_ks@hotmail.com> writes:
> > Below is a copy of my sql sentence including the error I am getting. What
> > does the error mean? What have I done wrong?
> >
> > kathrirs=# insert into faglaerer
> > kathrirs-# values ('f-001', '13056802876', 'Petter Lær',
> > lo_import('/home/studenter/it03/kathrirs/img/img01.jpg'),<----1
> > kathrirs(# '2001-12-25', 100, 'Professor', 'A', 1,<------2
> > '{"linux","programmering","matematikk","neutrale nettverk"}',
> > kathrirs(# 12, 'petter.laer@dih.no', '8212');
> > ERROR:  Invalid regular expression: parentheses ( ) not balanced
>
> There's no regular expression in what you've shown us.  Maybe you have
> rules or triggers that are fired by this INSERT?  If so, you need to
> look at what they are doing.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org

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.
--
Adrian Klaver
aklaver@comcast.net


Re: ERROR: Invalid regular expression: parentheses ( ) not balanced

From
Tom Lane
Date:
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