On Wednesday 25 August 2004 07:21 pm, Tom Lane wrote: > "Kathrine S" <[EMAIL PROTECTED]> 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, '[EMAIL PROTECTED]', '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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend