Re: [HACKERS] Add check constraint bug

2002-09-05 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Is there a TODO here? I've committed a fix for the immediate problem. I want to take a very hard look at the other heap_mark4update calls, though. regards, tom lane ---(end of broadcast)

Re: [HACKERS] Add check constraint bug

2002-09-05 Thread Bruce Momjian
Is there a TODO here? --- Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > The following happens in latest CVS and a fresh database: > > create table test (a int); > > insert into test values (1); > > alte

Re: [HACKERS] Add check constraint bug

2002-09-05 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > The following happens in latest CVS and a fresh database: > create table test (a int); > insert into test values (1); > alter table test add column b text check (b <> ''); This bug's been there awhile I fear. The failure occurs when AlterTableAddCol

Re: [HACKERS] Add check constraint bug

2002-09-05 Thread scott.marlowe
On Thu, 5 Sep 2002, Stephan Szabo wrote: > > On Thu, 5 Sep 2002, Peter Eisentraut wrote: > > > The following happens in latest CVS and a fresh database: > > > > create table test (a int); > > insert into test values (1); > > alter table test add column b text check (b <> ''); > > alter table te

Re: [HACKERS] Add check constraint bug

2002-09-05 Thread Stephan Szabo
On Thu, 5 Sep 2002, Peter Eisentraut wrote: > The following happens in latest CVS and a fresh database: > > create table test (a int); > insert into test values (1); > alter table test add column b text check (b <> ''); > alter table test add check (a > 0); > alter table test add check (a <> 1);