Re: ERROR: Invalid regular expression: parentheses ( ) not balanced - Mailing list pgsql-sql

From Tom Lane
Subject Re: ERROR: Invalid regular expression: parentheses ( ) not balanced
Date
Msg-id 11200.1093486890@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: Invalid regular expression: parentheses ( ) not balanced  ("Kathrine S" <skybert_ks@hotmail.com>)
Responses Re: ERROR: Invalid regular expression: parentheses ( ) not balanced  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-sql
"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'),
> 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE TYPE VARCHAR2
Next
From: Adrian Klaver
Date:
Subject: Re: ERROR: Invalid regular expression: parentheses ( ) not balanced