The following bug has been logged online:
Bug reference: 2971
Logged by: Martin Pitt
Email address: martin(at)piware(dot)de
PostgreSQL version: 8.2.2
Operating system: Linux
Description: 8.1.7/8.2.2 break constraint checking for 'update'
Details:
Originally reported on https://launchpad.net/bugs/83505:
db> create table foo (bar VARCHAR(20) NOT NULL check (bar in
('FOO','BAR')));
CREATE TABLE
db> insert into foo (bar) values ('FOO');
INSERT 0 1
db> update foo set bar = 'BAR';
ERROR: attribute 1 has wrong type
DETAIL: Table has type character varying, but query expects character
varying.
This worked in the previous versions (8.2.1/8.1.6). I checked that it does
not affect 7.4.16.
Thank you!