Read the documentation about the new warning, and use double
single-quotes in the string, or E'' strings.
---------------------------------------------------------------------------
postgres@bilteks.com wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +