Re: [GENERAL] CHECK constraint fails when it's not supposed to

2009-08-04 Thread Tom Lane
Richard Yen writes: > When I run my update, it fails: >> tii=# begin; update only "public"."m_class" set date_end='2009-09-03 >> 05:38:24.030331-07',term_length='177 days 17:59:09.868431' where >> id='2652020'; >> BEGIN >> ERROR: new row for relation "m_class" violates check constraint >> "end_wi

[GENERAL] CHECK constraint fails when it's not supposed to

2009-08-04 Thread Richard Yen
Hi All, I encountered an odd issue regarding check constraints complaining when they're not really violated. For this particular machine, I am running 8.3.7, but on a machine running 8.3.5, it seems to have succeeded. I also upgraded a third machine from 8.3.5 to 8.3.7, and the query succeeded (