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. +
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 |