Re: regression in 8.8.2 [was Re: Very strange error] - Mailing list pgsql-general

Bruce Momjian wrote:
> Andrea Arcangeli wrote:

> > Actually I'm using the REL8_2_STABLE branch in CVS which may be a bit
> > more advanced than the plain 8.2.2, but still it's supposedly a stable
> > branch.
> >
> > The easiest way for me to reproduce is this:
> >
> > cpushare=> create table x (x NUMERIC(28,2) CHECK(x >= 0));
> > CREATE TABLE
> > cpushare=> insert into x values (0);
> > INSERT 0 1
> > cpushare=> update x set x = 0;
> > ERROR:  attribute 1 has wrong type
> > DETAIL:  Table has type numeric, but query expects numeric.
> > cpushare=>
> >
> > Comments welcome. Thanks!
>
> This is a known bug in 8.2.2 and we are discussing methods of
> distributing the fix as quickly as possible.

The fix is already in the REL8_2_STABLE branch, so Andrea can certainly
update and confirm if his problem is fixed.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.