Re: Add check constraint bug

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.