Re: [PORTS] Port Bug Report: Regexp does not allow alternation in CHECK clause
От | Bruce Momjian |
---|---|
Тема | Re: [PORTS] Port Bug Report: Regexp does not allow alternation in CHECK clause |
Дата | |
Msg-id | 199905101644.MAA07698@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Port Bug Report: Regexp does not allow alternation in CHECK clause (Unprivileged user <nobody>) |
Список | pgsql-ports |
Added to TODO list. > > ============================================================================ > 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: > --------- > > > -------------------------------------------------------------------------- > > > -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
В списке pgsql-ports по дате отправления: