| From: | Unprivileged user <nobody> |
|---|---|
| To: | pgsql-ports(at)postgresql(dot)org |
| Subject: | Port Bug Report: Regexp does not allow alternation in CHECK clause |
| Date: | 1999-04-30 19:07:49 |
| Message-ID: | 199904301907.PAA83888@hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-ports |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Raphael Finkel
Your email address : raphael(at)cs(dot)uky(dot)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:
---------
--------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albert REINER | 1999-04-30 20:18:45 | Installation |
| Previous Message | Unprivileged user | 1999-04-30 19:05:52 | Port Bug Report: Can't add nth element of array that has n-1 elts. |