From: | "" <postgres(at)bilteks(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2722: DBD::Pg v1.49 quoting generate warning |
Date: | 2006-10-26 01:00:00 |
Message-ID: | 200610260100.k9Q100PB004304@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2722
Logged by:
Email address: postgres(at)bilteks(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Simon | 2006-10-26 06:11:36 | BUG #2723: Provider / driver connection for VB.NET |
Previous Message | Tom Lane | 2006-10-26 00:15:23 | Re: BUG #2712: could not fsync segment: Permission |