Javier Barroso, 2008-09-13 15:58:43 +0200 : > I'm posting this bug, because db-upgraded tells me about: [...] > Upgrading with 20070924-forum-perm.sql > DBD::Pg::st execute failed: ERROR: no se puede convertir el tipo character > varying a integer [...] > I'm trying to upgrade from gforge database on a old redhat. > > My postgres server version is 7.4
I've finally found out what happens with this bug. The 20070924-forum-perm.sql file creates a view that displays as an integer a field (from a table) that's declared as text. Fortunately, the WHERE clause ensures that only rows where the field has an integer value are returned by the view. But PostgreSQL 7.4 seems to try to cast all rows before applying the clause, so some of the rows don't fit. Upgrading to PostgreSQL 8.1 (or later) fixes the problem. I guess the package dependencies should be made stricter. Roland. -- Roland Mas $ chown -R us:us your_base* -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
