Tom Lane wrote: > Oliver Jowett <[EMAIL PROTECTED]> writes: > > Bruce Momjian wrote: > >> I have received very few replies to my suggestion that we implement E'' > >> for escaped strings, so eventually, after a few major releases, we can > >> have '' treat backslashes literally like the SQL standard requires. > > > Just checking: with this plan, a client needs to know what server > > version is in use to correctly escape strings, correct? That is, there > > is no escape mechanism that works correctly for both "old" and "new" > > servers? > > When the change happens, yes, it will be non compatible. I don't > recommend thinking of it as a "server version" check though --- we > will put in a read-only GUC variable (like the one for integer > datetimes) and you can check it through the parameter reporting > mechanism.
Right, the GUC read-only variables are already in the patch URL I posted. -- 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 8: explain analyze is your friend