[rt-users] FYI: database upgrade & bug in DBD::Pg 3.4.1

[Václav Ovsík]

Hi,
I found a bug in the DBD::Pg 3.4.1 yesterday
https://rt.cpan.org/Public/Bug/Display.html?id=99144
The problem was fixed very quickly and the new version 3.4.2 was
released.

The upgrade failed for etc/upgrade/3.9.8/content, details are in the
bug-report above.

...
Processing 3.9.8
Now populating database schema.
Now inserting data.      
[8237] [Thu Sep 25 15:20:56 2014] [warning]: DBD::Pg::db table_info failed: ERROR:  operator does not exist: text = integer
LINE 34:                 ) ti WHERE "TABLE_TYPE" IN (1)
                                                 ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. at /opt/interni/sbin/../lib/RT/Handle.pm line 1739, <> line 1. (/opt/interni/sbin/../lib/RT/Handle.pm:1739)
Couldn't finish 'upgrade' step.
                         
ERROR: One of initial functions failed: DBD::Pg::db table_info failed: ERROR:  operator does not exist: text = integer
LINE 34:                 ) ti WHERE "TABLE_TYPE" IN (1)
                                                 ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. at /opt/interni/sbin/../lib/RT/Handle.pm line 1739, <> line 1.              


Maybe this can help someone...
-- 
Zito