Public bug reported: Binary package hint: postgresql-8.1
After upgrading postgresql-8.1 to the latest version (8.1.4-7ubuntu0.2) this morning (as per http://www.ubuntu.com/usn/usn-417-1), my pgsql- based application breaks. Turned out that this was the cause: db=> update accounts set status='active' where status='active'; ERROR: attribute 5 has wrong type DETAIL: Table has type character varying, but query expects character varying. db=> \d accounts Table "public.accounts" Column | Type | Modifiers -------------+--------------------------+------------------------------------------------------- id | bigint | not null default nextval('accounts_id_seq'::regclass) name | character varying(500) | not null type | character varying(50) | not null default 'regular'::character varying comments | text | status | character varying(50) | not null default 'pending'::character varying ... Check constraints: "accounts_status_check" CHECK (status::text = 'active'::text OR status::text = 'pending'::text OR status::text = 'suspended'::text OR status::text = 'expired'::text OR status::text = 'deleted'::text) ... This does not happen when I downgrade the postgresql-8.1 package to 8.1.4-7ubuntu0.1 manually. ** Affects: postgresql-8.1 (Ubuntu) Importance: Undecided Status: Unconfirmed -- postgresql update breaks check constraints https://launchpad.net/bugs/83519 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs