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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Replace SYSTEMQUOTEs with Windows-specific wrapper functions.
Date: 2014-05-14 23:24:46
Message-ID: CAB7nPqTh+=j=RxKX=usJB0J1o7Yaj6oKnD=cUwjG_P+Drku=sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On Thu, May 15, 2014 at 12:02 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> 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(at)momjian(dot)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.
Thanks!
--
Michael

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2014-05-15 00:23:36 pgsql: Fix version check for pg_upgrade line type crosscheck.
Previous Message Bruce Momjian 2014-05-14 20:27:10 Re: pgsql: Fix pg_type.typlen for newly-revived line type.