Re: [HACKERS] standard_conforming_strings

2010-07-20 Thread Marko Kreen
On 7/20/10, Peter Eisentraut pete...@gmx.net wrote: On sön, 2010-07-18 at 09:42 -0700, David E. Wheeler wrote: On Jul 18, 2010, at 1:35 AM, Peter Eisentraut wrote: I think there are two ways we can do this, seeing that most appear to be in favor of doing it in the first place:

Re: [HACKERS] standard_conforming_strings

2010-07-20 Thread Peter Eisentraut
On tis, 2010-07-20 at 13:31 +0300, Marko Kreen wrote: http://wiki.postgresql.org/wiki/Standard_conforming_strings There is two sorts of support: 1. Detect stdstr on startup and use that setting. 2. Detect online changes to stdstr and follow them. AFAICS psycopg does not support 2).

Re: [HACKERS] standard_conforming_strings

2010-07-19 Thread Peter Eisentraut
On sön, 2010-07-18 at 09:42 -0700, David E. Wheeler wrote: On Jul 18, 2010, at 1:35 AM, Peter Eisentraut wrote: I think there are two ways we can do this, seeing that most appear to be in favor of doing it in the first place: Either we just flip the default, make a note in the release

Re: [HACKERS] standard_conforming_strings

2010-07-19 Thread Robert Haas
On Mon, Jul 19, 2010 at 5:04 PM, Peter Eisentraut pete...@gmx.net wrote: On sön, 2010-07-18 at 09:42 -0700, David E. Wheeler wrote: On Jul 18, 2010, at 1:35 AM, Peter Eisentraut wrote: I think there are two ways we can do this, seeing that most appear to be in favor of doing it in the first

Re: [HACKERS] standard_conforming_strings

2010-07-19 Thread Robert Haas
On Mon, Jul 19, 2010 at 8:32 PM, Robert Haas robertmh...@gmail.com wrote: On Mon, Jul 19, 2010 at 5:04 PM, Peter Eisentraut pete...@gmx.net wrote: On sön, 2010-07-18 at 09:42 -0700, David E. Wheeler wrote: On Jul 18, 2010, at 1:35 AM, Peter Eisentraut wrote: I think there are two ways we can

Re: [HACKERS] standard_conforming_strings

2010-07-18 Thread Peter Eisentraut
On ons, 2010-07-14 at 10:48 -0400, Robert Haas wrote: On Fri, Jan 29, 2010 at 10:02 PM, Josh Berkus j...@agliodbs.com wrote: An actual plan here might look like let's flip it before 9.1alpha1 so we can get some alpha testing cycles on it ... Hey, let's flip it in 9.1 CF 1, so that we can

Re: [HACKERS] standard_conforming_strings

2010-07-18 Thread David E. Wheeler
On Jul 18, 2010, at 1:35 AM, Peter Eisentraut wrote: I think there are two ways we can do this, seeing that most appear to be in favor of doing it in the first place: Either we just flip the default, make a note in the release notes, and see what happens. Or we spend some time now and make,

Re: [HACKERS] standard_conforming_strings

2010-07-18 Thread Tom Lane
David E. Wheeler da...@kineticode.com writes: On Jul 18, 2010, at 1:35 AM, Peter Eisentraut wrote: I think there are two ways we can do this, seeing that most appear to be in favor of doing it in the first place: Either we just flip the default, make a note in the release notes, and see what

Re: [HACKERS] standard_conforming_strings

2010-07-15 Thread Robert Haas
On Jul 15, 2010, at 12:30 AM, Richard Huxton d...@archonet.com wrote: On 14/07/10 15:48, Robert Haas wrote: On Fri, Jan 29, 2010 at 10:02 PM, Josh Berkusj...@agliodbs.com wrote: An actual plan here might look like let's flip it before 9.1alpha1 so we can get some alpha testing cycles on it

Re: [HACKERS] standard_conforming_strings

2010-07-15 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Jul 15, 2010, at 12:30 AM, Richard Huxton d...@archonet.com wrote: Any reason not to add a line to the 9.0 docs/release notes saying WARNING: The PGDG currently plan to change this setting's default in 9.1? Well, mostly that we could change our

[HACKERS] standard_conforming_strings

2010-07-14 Thread Robert Haas
On Fri, Jan 29, 2010 at 10:02 PM, Josh Berkus j...@agliodbs.com wrote: An actual plan here might look like let's flip it before 9.1alpha1 so we can get some alpha testing cycles on it ... Hey, let's flip it in 9.1 CF 1, so that we can have some alpha testing cycles on it. Should we do this?

Re: [HACKERS] standard_conforming_strings

2010-07-14 Thread Bruce Momjian
Robert Haas wrote: On Fri, Jan 29, 2010 at 10:02 PM, Josh Berkus j...@agliodbs.com wrote: An actual plan here might look like let's flip it before 9.1alpha1 so we can get some alpha testing cycles on it ... Hey, let's flip it in 9.1 CF 1, so that we can have some alpha testing cycles on

Re: [HACKERS] standard_conforming_strings

2010-07-14 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Fri, Jan 29, 2010 at 10:02 PM, Josh Berkus j...@agliodbs.com wrote: An actual plan here might look like let's flip it before 9.1alpha1 so we can get some alpha testing cycles on it ... Hey, let's flip it in 9.1 CF 1, so that we can have some alpha

Re: [HACKERS] standard_conforming_strings

2010-07-14 Thread Richard Huxton
On 14/07/10 15:48, Robert Haas wrote: On Fri, Jan 29, 2010 at 10:02 PM, Josh Berkusj...@agliodbs.com wrote: An actual plan here might look like let's flip it before 9.1alpha1 so we can get some alpha testing cycles on it ... Hey, let's flip it in 9.1 CF 1, so that we can have some alpha

[HACKERS] standard_conforming_strings 'on' for 8.3?

2007-01-30 Thread Bruce Momjian
Are we going to turn on standard_conforming_strings for 8.3? We discussed the idea when we added it in 8.1, and enabled the backslash warning in 8.2. We have gotten almost no pushback on the warning, so it seems enabling it might be good. Right now, for default postgresql.conf, users are

Re: [HACKERS] standard_conforming_strings 'on' for 8.3?

2007-01-30 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Are we going to turn on standard_conforming_strings for 8.3? I'd be inclined to wait a bit longer, i.e., 8.4, seeing that this is intended to be a short release cycle. 8.2 has not been out long enough to draw any meaningful conclusions about whether we

Re: [HACKERS] standard_conforming_strings 'on' for 8.3?

2007-01-30 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Are we going to turn on standard_conforming_strings for 8.3? I'd be inclined to wait a bit longer, i.e., 8.4, seeing that this is intended to be a short release cycle. 8.2 has not been out long enough to draw any meaningful

[HACKERS] standard_conforming_strings vs escape_string_warning

2006-05-09 Thread Tom Lane
I see that in CVS head, if you turn on standard_conforming_strings, it still whines about backslashes: regression=# set standard_conforming_strings to 1; SET regression=# select '1234\5678'; WARNING: nonstandard use of escape in a string literal LINE 1: select '1234\5678'; ^ HINT: