[Wellington-pm] postgres 8.x and escaping E'' style
katrina at catalyst.net.nz
Wed Feb 18 13:42:01 PST 2009
The jdbc postgres library has the same problem.
To suppress the warnings, you can set the following in your postgres
standard_conforming_strings = off
On Fri, 2009-02-13 at 17:52 +1100, Andrew Boag wrote:
> 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
> Wellington-pm mailing list
> Wellington-pm at pm.org
More information about the Wellington-pm