Bug#537117: libdbix-searchbuilder-perl: attempts to lower() timestamps on postgresql

[MJ Ray]

Package: libdbix-searchbuilder-perl
Version: 1.54-1
Severity: normal

I upgraded a system to lenny and many "rt ls" searches stopped working.
Viewing the logs discovered that request-tracker3.6 command line client
was resulting in a call to lower() on a timestamp, which isn't a common
function in postgresql and I didn't find it in postgresql-contrib.

http://lists.fsck.com/pipermail/rt-users/2009-March/057942.html
hinted at one solution: replace \d with [-\d: ] in a regex in
SearchBuilder.pm function MakeClauseCaseInsensitive.

-- System Information:
Debian Release: 5.0.2
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)


Versions of packages libdbix-searchbuilder-perl depends on:
ii  libcache-simple-timedexpiry-p 0.27-2     Perl module to cache and expire ke
ii  libclass-accessor-perl        0.31-2     Automated accessor generator
ii  libclass-returnvalue-perl     0.55-1     A return-value object that lets yo
ii  libclone-perl                 0.29-1     recursively copy Perl datatypes
ii  libdbd-mysql-perl             4.007-1    A Perl5 database interface to the
ii  libdbd-pg-perl                2.8.7-1    Perl DBI driver for the PostgreSQL
ii  libdbd-sqlite3-perl           1.14-3     Perl DBI driver with a self-contai
ii  libdbix-dbschema-perl         0.36-1     Database-independent schema object
ii  libwant-perl                  0.18-1+b1  A generalisation of wantarray
ii  perl                          5.10.0-19  Larry Wall's Practical Extraction

libdbix-searchbuilder-perl recommends no packages.

libdbix-searchbuilder-perl suggests no packages.

-- no debconf information

-- 
MJR/slef
My Opinion Only: see http://people.debian.org/~mjr/
Please follow http://www.uk.debian.org/MailingLists/#codeofconduct