X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 98E8A5E46F3 for ; Wed, 25 Aug 2004 23:21:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43347-05 for ; Thu, 26 Aug 2004 02:21:27 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 84EDE5E46F2 for ; Wed, 25 Aug 2004 23:21:25 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i7Q2LUL6011201; Wed, 25 Aug 2004 22:21:30 -0400 (EDT) To: "Kathrine S" Cc: pgsql-sql@postgresql.org Subject: Re: ERROR: Invalid regular expression: parentheses ( ) not balanced In-reply-to: References: Comments: In-reply-to "Kathrine S" message dated "Sun, 22 Aug 2004 21:51:34 +0200" Date: Wed, 25 Aug 2004 22:21:30 -0400 Message-ID: <11200.1093486890@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/277 X-Sequence-Number: 18774 "Kathrine S" 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'), > kathrirs(# '2001-12-25', 100, 'Professor', 'A', 1, > '{"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