Re: string escaping in tutorial/syscat.source

On Tue, Jan 15, 2013 at 6:35 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:

> Do you propose back-patching this? You could argue that this is a bug in
> 9.1 and 9.2. Before that, they generate deprecation warnings, but do not
> give the wrong answer.

I think that backpatching to 9.1 would be reasonable, though I won't
complain if the fix is only applied to HEAD.

> If it is only to be applied to HEAD, or only to 9.1, 9.2, and HEAD, then
> this part seems to be unnecessary and I think should be removed (setting a
> value to its default is more likely to cause confusion than remove
> confusion):
>
> SET standard_conforming_strings TO on;
>
> and the corresponding reset as well.

Well, it may be unnecessary for people who use the modern default
standard_conforming_strings. But some people have kept
standard_conforming_strings=off in recent versions because they have
old code which depends on this. And besides, it seems prudent to make
the dependency explicit, rather than just hoping the user has the
correct setting, and silently giving wrong results if not. Plus being
able to work with old server versions.

> Other than that, it does what it says (fix a broken example), does it
> cleanly, we want this, and I have no other concerns.
>
> I guess the src/tutorial directory could participate in regression tests, in
> which case this problem would have been detected when introduced, but I
> don't think I can demand that you invent regression tests for a feature you
> are just fixing rather than creating.

Yeah, I don't think tying into the regression tests is warranted here.

Josh