I think we we will be turning on escape_string_warning in 8.2 and allow standard_conforming_strings to be optionally turned on in that releaes. I will keep the patch for us in completing that item.
This has been saved for the 8.2 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --------------------------------------------------------------------------- Kevin Grittner wrote: > I've just been bitten by the "backslash in string literals" issue. I > have reviewed the mailing lists and the TODO list. I see that the > direction PostgreSQL is headed is to drop the nonstandard escapes, > unless an extended literal is explicitly used. I've attached a patch > which supports this as a configure option, using a > --enable-standard-strings switch. It's probably somewhat naive, but > maybe it can be helpful. > > -Kevin > > [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings