From: Adrian Klaver <aklaver@comcast.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: 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 19:44:52 -0700
Message-ID: <200408251944.52693.aklaver@comcast.net> (raw)
In-Reply-To: <11200.1093486890@sss.pgh.pa.us>
References: <cP6Wc.40160$Vf.2070014@news000.worldonline.dk>
<11200.1093486890@sss.pgh.pa.us>
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
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: aklaver@comcast.net, tgl@sss.pgh.pa.us, skybert_ks@hotmail.com
Subject: Re: ERROR: Invalid regular expression: parentheses ( ) not balanced
In-Reply-To: <200408251944.52693.aklaver@comcast.net>
* 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