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

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