Skip site navigation (1) Skip section navigation (2)

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

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: (view raw, whole thread or download thread mbox)
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

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

use DBI;
my $text='text\\test';
print "text_before=[$text]\n";
print "text_after=[$text]\n";
$DBH->do("SELECT $text");


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


pgsql-bugs by date

Next:From: SimonDate: 2006-10-26 06:11:36
Subject: BUG #2723: Provider / driver connection for VB.NET
Previous:From: Tom LaneDate: 2006-10-26 00:15:23
Subject: Re: BUG #2712: could not fsync segment: Permission

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group