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 test add check (a > 0); > > alter table test add check (a <> 1); > > > > After the last command I get > > > > ERROR: CheckConstraintFetch: unexpected record found for rel test > > > > and then the table seems to be wedged because any access to it will get > > the same error.
Just fyi, 7.2.1 does this too. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
