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.
