[Pkg-dspam-misc] Bug#445890: libdspam7-drv-pgsql: incompatible escaping with psql 8.2, generates lots of warnings (HINT: Use the escape string syntax for backslashes, e.g., E'\\'.)

[Peter Gervai]

Package: libdspam7-drv-pgsql
Version: 3.6.8-5+b1
Severity: important

The driver generates a warning and a hint for every trained message under
psql8.2 and later:

WARNING:  nonstandard use of \\ in a string literal
LINE 1: ..., '3,470ab5ae76601198567559', 5640, CURRENT_DATE, '\\000\\00...
                                                              ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.

A longer description is at:
http://mailing-list.nuclearelephant.com/6068.html

Which basically comes down to:
...you'd probably be better served rewriting dspam's quoting routines to use 
PQescapeStringConn(), so as to ensure correct quoting is used...

which should be applied to at least to pgsql_drv.c line #1234.

(I see no other obvious occurences of the said problem.)

-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (2000, 'unstable'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.22.1-narya (SMP w/2 CPU cores; PREEMPT)
Locale: LANG=C, LC_CTYPE=hu_HU (charmap=ISO-8859-2)
Shell: /bin/sh linked to /bin/bash

Versions of packages libdspam7-drv-pgsql depends on:
ii  dbconfig-common              1.8.35      common framework for packaging dat
ii  debconf [debconf-2.0]        1.5.13      Debian configuration management sy
ii  libc6                        2.6.1-5     GNU C Library: Shared libraries
ii  libdspam7                    3.6.8-5+b1  DSPAM is a scalable and statistica
ii  libldap2                     2.1.30-13.4 OpenLDAP libraries
ii  libpq5                       8.2.4-2     PostgreSQL C client library
ii  postgresql-client            8.2.5-1     front-end programs for PostgreSQL 
ii  postgresql-client-8.2 [postg 8.2.5-1     front-end programs for PostgreSQL 
ii  ucf                          3.001       Update Configuration File: preserv

Versions of packages libdspam7-drv-pgsql recommends:
pn  postgresql-8.1                <none>     (no description available)

-- debconf information excluded