[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