Public bug reported:
Binary package hint: postgresql-8.1
USN-417-1 advised upgrading PostgreSQL. After the upgrade, some SQL in
my app failed. This fragment shows the problem:
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.
The error occurs in Edgy AMD64, Edgy i386 and Dapper AMD64. On a Dapper
AMD64 machine which I did not yet upgrade, the SQL commands succeed.
The only workaround I can find at the moment is to remove the check
constraint.
** Affects: postgresql-8.1 (Ubuntu)
Importance: Undecided
Status: Unconfirmed
--
Breakage in Feb 5 security update
https://launchpad.net/bugs/83505
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
