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

Martyn Smith martyn at catalyst.net.nz
Thu Feb 12 21:03:47 PST 2009


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
> 


More information about the Wellington-pm mailing list