Port Bug Report: Regexp does not allow alternation in CHECK clause - Mailing list pgsql-ports

From Unprivileged user
Subject Port Bug Report: Regexp does not allow alternation in CHECK clause
Date
Msg-id 199904301907.PAA83888@hub.org
Whole thread Raw
Responses Re: [PORTS] Port Bug Report: Regexp does not allow alternation in CHECK clause  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Raphael Finkel
Your email address      : raphael@cs.uky.edu

Category                : runtime: back-end: SQL
Severity                : non-critical

Summary: Regexp does not allow alternation in CHECK clause

System Configuration
--------------------
  Operating System   : Linux 2.0.36 ELF Slackware

  PostgreSQL version : 6.4.2

  Compiler used      : egcs-2.90.29egcs-2.90.29

Hardware:
---------
Linux zonker 2.0.36 #2 Sun Jan 10 17:51:07 EST 1999 i686 unknown



Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
I can SELECT ... WHERE col ~ '(foo|bar)', but if I
put a CHECK clause on a CREATE TABLE with the same
expression, the check always fails.

--------------------------------------------------------------------------

Test Case:
----------


--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


pgsql-ports by date:

Previous
From: Unprivileged user
Date:
Subject: Port Bug Report: Can't add nth element of array that has n-1 elts.
Next
From: Eric Buddington
Date:
Subject: Build in separate directory fails: funky path contatenation