Re: pgsql: Replace SYSTEMQUOTEs with Windows-specific wrapper functions. - Mailing list pgsql-committers

From Bruce Momjian
Subject Re: pgsql: Replace SYSTEMQUOTEs with Windows-specific wrapper functions.
Date
Msg-id 20140514150227.GB31386@momjian.us
Whole thread Raw
In response to Re: pgsql: Replace SYSTEMQUOTEs with Windows-specific wrapper functions.  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: pgsql: Replace SYSTEMQUOTEs with Windows-specific wrapper functions.  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-committers
On Tue, May 13, 2014 at 08:19:22AM +0900, Michael Paquier wrote:
> On Tue, May 13, 2014 at 8:18 AM, Bruce Momjian <bruce@momjian.us> wrote:
> > On Mon, May  5, 2014 at 01:08:32PM +0000, Heikki Linnakangas wrote:
> >> Replace SYSTEMQUOTEs with Windows-specific wrapper functions.
> >>
> >> It's easy to forget using SYSTEMQUOTEs when constructing command strings
> >> for system() or popen(). Even if we fix all the places missing it now, it is
> >> bound to be forgotten again in the future. Introduce wrapper functions that
> >> do the the extra quoting for you, and get rid of SYSTEMQUOTEs in all the
> >> callers.
> >>
> >> We previosly used SYSTEMQUOTEs in all the hard-coded command strings, and
> >> this doesn't change the behavior of those. But user-supplied commands, like
> >> archive_command, restore_command, COPY TO/FROM PROGRAM calls, as well as
> >> pgbench's \shell, will now gain an extra pair of quotes. That is desirable,
> >> but if you have existing scripts or config files that include an extra
> >> pair of quotes, those might need to be adjusted.
> >
> > Should this be mentioned as an incompatibility in the 9.4 release notes?
> Definitely worth mentioning.

Done with the attached applied patch.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

Attachment

pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgsql: docs: mention windows quoting change in 9.4 release notes
Next
From: Tom Lane
Date:
Subject: pgsql: Make initdb throw error for bad locale values.