[Wellington-pm] postgres 8.x and escaping E'' style

Andrew Boag andrew.boag at catalyst.net.nz
Thu Feb 12 22:52:16 PST 2009


Worse, it's Solaris!!!!

And worse still is that we're installing modules from CPAN!!!!

Oh well, better get it working then.

Martyn Smith wrote:
> DBD::Pg does this already from version:
>
> 2.7.0 Released May 10, 2008 (subversion r11239)
>
> Unfortunately Etch has 1.49
>
> Lenny however has 2.8.7 :-)
>
> So I suspect you're usinging a version of libdbd-pg-perl from etch (or
> perhaps some Ubuntu version pre-2.7.0)
>
> Hopefully that helps.
>
> On Fri, Feb 13, 2009 at 03:26:08PM +1100, Andrew Boag wrote:
>   
>> As part of migrating to postgres 8.2 with our application we have
>> started seeing these warning messages in the logs:
>>
>> WARNING:  nonstandard use of \\ in a string literal at character 230
>> HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
>>
>> At the moment we are just logging (ignoring) these messages ... but not
>> forever.
>>
>> I know what is causing this. It's the that postgres wants to escape
>> strings using the E'text to escape \' format where the forward slash
>> will not escape the single quote.
>>
>> I would like to not have to worry about this syntax to be honest. Can't
>> the DBI library be updated or configured to take care of this?
>>
>> Thoughts?
>> _______________________________________________
>> Wellington-pm mailing list
>> Wellington-pm at pm.org
>> http://mail.pm.org/mailman/listinfo/wellington-pm
>>
>>     
> _______________________________________________
> Wellington-pm mailing list
> Wellington-pm at pm.org
> http://mail.pm.org/mailman/listinfo/wellington-pm
>
>   



More information about the Wellington-pm mailing list