Re: backslashes in 8.3.3

From: "Brandon Metcalf" <bmetcalf(at)nortel(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: backslashes in 8.3.3
Date: 2008-06-24 16:46:44
Message-ID: Pine.LNX.4.58L.0806241143501.9186@cash.us.nortel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

t == tgl(at)sss(dot)pgh(dot)pa(dot)us writes:

t> "Brandon Metcalf" <bmetcalf(at)nortel(dot)com> writes:
t> > t == tgl(at)sss(dot)pgh(dot)pa(dot)us writes:
t> > t> See standard_conforming_strings and escape_string_warning.

t> > Excellent. I had missed the standard_conforming_strings and will turn
t> > this on. Hold on. Yes, that did it. Thanks so much.

t> Well, if your intent is to replicate 8.1's behavior, you should instead
t> frob the other switch.

I now have

escape_string_warning = off

and

standard_conforming_strings = on

in postgresql.conf and things are back to how they were. That is no
warnings and backslashes treated literally.

A related question, is it in any way possible that a control sequence
could have been sent from a client that caused a fast shutdown? Our
server log shows a fast shutdown request last night, but nobody
manually issued such a request.

--
Brandon

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-06-24 16:57:26 Re: backslashes in 8.3.3
Previous Message Ryan Wells 2008-06-24 16:31:16 String Encoding Conversion Problem