| 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: | Whole Thread | Raw Message | 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
| 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 |