BUG #2722: DBD::Pg v1.49 quoting generate warning

The following bug has been logged online:

Bug reference:      2722
Logged by:
Email address:      postgres@bilteks.com
PostgreSQL version: 8.2beta1
Operating system:   FreeBSD 6.1
Description:        DBD::Pg v1.49 quoting generate warning
Details:

Current edition of DBD::Pg generate warning with default settings of
'escape_string_warning'=on and 'standard_conforming_strings'=off. Sample
below:

use DBI;
my
$DBH=DBI->connect('DBI:Pg:dbname=YourDB','login','password',{RaiseError=>'on
'});
my $text='text\\test';
print "text_before=[$text]\n";
$text=$DBH->quote($text);
print "text_after=[$text]\n";
$DBH->do("SELECT $text");

Result:
text_before=[text\test]
text_after=['text\\test']

DB Log:
2006-10-26 03:53:31 xxxx 77865 WARNING:  nonstandard use of \\ in a string
literal at character 8
2006-10-26 03:53:31 xxxx 77865 HINT:  Use the escape string syntax for
backslashes, e.g., E'\\'.
2006-10-26 03:53:31 xxxx 77865 STATEMENT:  SELECT 'text\\test'

Best regards,
 Alexander Kirpa