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

From Michael Paquier
Subject Re: pgsql: Replace SYSTEMQUOTEs with Windows-specific wrapper functions.
Date
Msg-id CAB7nPqRR5mejLrmR4xH9=-JjAx+JHbPKwe4_bfMTv3cN+MH9og@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Replace SYSTEMQUOTEs with Windows-specific wrapper functions.  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pgsql: Replace SYSTEMQUOTEs with Windows-specific wrapper functions.  (Bruce Momjian <bruce@momjian.us>)
List pgsql-committers
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.
--
Michael


pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgsql: Replace SYSTEMQUOTEs with Windows-specific wrapper functions.
Next
From: Bruce Momjian
Date:
Subject: Re: pgsql: Revive line type