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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kathrine S" <skybert_ks(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ERROR: Invalid regular expression: parentheses ( ) not balanced
Date: 2004-08-26 02:21:30
Message-ID: 11200.1093486890@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Kathrine S" <skybert_ks(at)hotmail(dot)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 Lr',
> 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(dot)laer(at)dih(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2004-08-26 02:44:52 Re: ERROR: Invalid regular expression: parentheses ( ) not balanced
Previous Message Tom Lane 2004-08-26 02:07:43 Re: CREATE TYPE VARCHAR2