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

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

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Kathrine S" <skybert_ks(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ERROR: Invalid regular expression: parentheses ( ) not balanced
Date: 2004-08-26 02:44:52
Message-ID: 200408251944.52693.aklaver@comcast.net (view raw or flat)
Thread:
Lists: pgsql-sql
On Wednesday 25 August 2004 07:21 pm, Tom Lane wrote:
> "Kathrine S" <skybert_ks(at)hotmail(dot)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(dot)laer(at)dih(dot)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(at)comcast(dot)net

In response to

Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2004-08-26 02:54:28
Subject: Re: ERROR: Invalid regular expression: parentheses ( ) not balanced
Previous:From: Tom LaneDate: 2004-08-26 02:21:30
Subject: Re: ERROR: Invalid regular expression: parentheses ( ) not balanced

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