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

[Bruce Momjian <bruce(at)momjian(dot)us>]

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