Package: spamassassin
Version: 3.2.1-1
Severity: normal

Postgresql has been transitioning from old style backslash escaping to
SQL standard syntax.  

>From the postgres 8.2 release docs
(http://www.postgresql.org/docs/8.2/interactive/sql-syntax-lexical.htmlhttp://www.postgresql.org/docs/8.2/interactive/sql-syntax-lexical.html)

 If the configuration parameter standard_conforming_strings is off, then
 PostgreSQL recognizes backslash escapes in both regular and escape
 string constants. This is for backward compatibility with the
 historical behavior, in which backslash escapes were always recognized.
 Although standard_conforming_strings currently defaults to off, the
 default will change to on in a future release for improved standards
 compliance. Applications are therefore encouraged to migrate away from
 using backslash escapes. If you need to use a backslash escape to
 represent a special character, write the constant with an E to be sure
 it will be handled the same way in future releases.

 In addition to standard_conforming_strings, the configuration
 parameters escape_string_warning and backslash_quote govern treatment
 of backslashes in string constants. 

E syntax is to prepend the string with an E.  So, instead of '\\027' it
would be E'\\027'.


Warning emited by sa-learn:

[29501] warn: WARNING: nonstandard use of \\ in a string literal
[29501] warn: LINE 1: select put_tokens(4, 
'{"\\\\002\\\\150\\\\062\\\\132\\\\166"...
[29501] warn:  ^
[29501] warn: HINT: Use the escape string syntax for backslashes, e.g., E'\\'.

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

Kernel: Linux 2.6.16.13-xenU (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash

Versions of packages spamassassin depends on:
ii  libarchive-tar-perl           1.34-1     Archive::Tar - manipulate tar file
ii  libdigest-sha1-perl           2.11-2     NIST SHA-1 message digest algorith
ii  libhtml-parser-perl           3.56-1     A collection of modules that parse
ii  libio-zlib-perl               1.04-1     IO:: style interface to Compress::
ii  libnet-dns-perl               0.60-1     Perform DNS queries from a Perl sc
ii  libsocket6-perl               0.19-1     Perl extensions for IPv6
ii  libsys-hostname-long-perl     1.4-1      Figure out the long (fully-qualifi
ii  libwww-perl                   5.805-1    WWW client/server library for Perl
ii  perl                          5.8.8-7    Larry Wall's Practical Extraction 

Versions of packages spamassassin recommends:
ii  gcc                          4:4.2.1-6   The GNU C compiler
ii  gnupg                        1.4.6-2     GNU privacy guard - a free PGP rep
ii  libc6-dev                    2.6.1-3     GNU C Library: Development Librari
ii  libmail-spf-query-perl       1:1.999.1-3 query SPF (Sender Policy Framework
ii  libsys-syslog-perl           0.18-3      Perl interface to the UNIX syslog(
ii  make                         3.81-3      The GNU version of the "make" util
ii  re2c                         0.12.1-1    tool for generating fast C-based r
ii  spamc                        3.2.1-1     Client for SpamAssassin spam filte

-- no debconf information



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to