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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: postgres(at)bilteks(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2722: DBD::Pg v1.49 quoting generate warning
Date: 2006-10-26 17:07:48
Message-ID: 200610261707.k9QH7mU26609@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Read the documentation about the new warning, and use double
single-quotes in the string, or E'' strings.

---------------------------------------------------------------------------

postgres(at)bilteks(dot)com wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-10-26 17:11:03 Re: BUG #2714: Wrong Result with static number
Previous Message Bruce Momjian 2006-10-26 17:02:37 Re: BUG #2721: configuration issue