Re: Add check constraint bug - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: Add check constraint bug
Date
Msg-id Pine.LNX.4.33.0209051657150.17154-100000@css120.ihs.com
Whole thread Raw
In response to Re: Add check constraint bug  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: beta1 packaged
Next
From: Tom Lane
Date:
Subject: Re: Add check constraint bug