Content-Type: text/plain;
  charset="iso-8859-1"
From: Adrian Klaver <aklaver@comcast.net>
Reply-To: aklaver@attbi.com
To: Tom Lane <tgl@sss.pgh.pa.us>,
	"Kathrine S" <skybert_ks@hotmail.com>
Subject: Re: ERROR: Invalid regular expression: parentheses ( ) not balanced
Date: Wed, 25 Aug 2004 19:44:52 -0700
User-Agent: KMail/1.4.3
Cc: pgsql-sql@postgresql.org
References: <cP6Wc.40160$Vf.2070014@news000.worldonline.dk>
	<11200.1093486890@sss.pgh.pa.us>
In-Reply-To: <11200.1093486890@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200408251944.52693.aklaver@comcast.net>

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. Wh=
at
> > does the error mean? What have I done wrong?
> >
> > kathrirs=3D# insert into faglaerer
> > kathrirs-# values ('f-001', '13056802876', 'Petter L=E6r',
> > 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=20
have marked 1 & 2 and involves the lo_import function. I have not used=20
lo_import and so do not know how to call it.  What I do see is that it is=
=20
called at 1 and a  '('  shows up to the  left of the prompt at 2 and stays=
=20
there indicating to me at least the parser is not happy.
--=20
Adrian Klaver=09
aklaver@comcast.net