> > SELECT ... WHERE col ~ '(foo|bar)' works, but CHECK on table always fails
>
> Does not reproduce here.
>
> test=> create table t2 (i text check(i ~ '(foo|bar)'));
> CREATE
> test=> insert into t1 values ('aaa');
> ERROR: ExecAppend: rejected due to CHECK constraint t1_i
> test=> insert into t1 values ('foo');
> INSERT 18634 1
Thanks. Removed.
-- 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,
Pennsylvania19026
