Public bug reported: Binary package hint: postgresql
The latest security version of postgres-8.1-8.1.4-7 causes errors during some table UPDATES on specific columns. THIS IS CRITICAL! I have been able to recreate on more than one install of 6.10. The bogus error message is something similar to: ERROR: attribute 13 has wrong type DETAIL: Table has type character varying, but query expects character varying. I will work on a simple schema and test case. Downgrading to 8.1.4-0ubuntu1.3 makes the problem go away. Affected packages: > dpkg -l | grep postgres ii postgresql-8.1 8.1.4-7ubuntu0.2 object-relational SQL database, version 8.1 ii postgresql-client-8.1 8.1.4-7ubuntu0.2 front-end programs for PostgreSQL 8.1 ii postgresql-client-common 62 manager for multiple PostgreSQL client versi ii postgresql-common 62 manager for PostgreSQL database clusters ii postgresql-contrib-8.1 8.1.4-7ubuntu0.2 additional facilities for PostgreSQL ii postgresql-plperl-8.1 8.1.4-7ubuntu0.2 PL/Perl procedural language for PostgreSQL 8 ii postgresql-plpython-8.1 8.1.4-7ubuntu0.2 PL/Python procedural language for PostgreSQL ii postgresql-pltcl-8.1 8.1.4-7ubuntu0.2 PL/TCL procedural language for PostgreSQL 8. Unaffected packages: > dpkg -l | grep postgres ii postgresql-8.1 8.1.4-0ubuntu1.3 object-relational SQL database, version 8.1 ii postgresql-client-8.1 8.1.4-0ubuntu1.3 front-end programs for PostgreSQL 8.1 ii postgresql-client-common 62 manager for multiple PostgreSQL client versi ii postgresql-common 62 manager for PostgreSQL database clusters ii postgresql-contrib-8.1 8.1.4-0ubuntu1.3 additional facilities for PostgreSQL ii postgresql-doc-8.1 8.1.4-0ubuntu1.3 documentation for the PostgreSQL database ma ii postgresql-plperl-8.1 8.1.4-0ubuntu1.3 PL/Perl procedural language for PostgreSQL 8 ii postgresql-plpython-8.1 8.1.4-0ubuntu1.3 PL/Python procedural language for PostgreSQL ii postgresql-pltcl-8.1 8.1.4-0ubuntu1.3 PL/TCL procedural language for PostgreSQL 8. ** Affects: postgresql (Ubuntu) Importance: Undecided Status: Unconfirmed -- postgres-8.1_8.1.4-7: Table has type character varying, but query expects character varying. https://launchpad.net/bugs/83641 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs