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

[Katrina Bassett]

The jdbc postgres library has the same problem.

To suppress the warnings, you can set the following in your postgres
config.

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
> http://mail.pm.org/mailman/listinfo/wellington-pm
>