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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Replace SYSTEMQUOTEs with Windows-specific wrapper functions.
Date: 2014-05-12 23:18:15
Message-ID: 20140512231815.GA16042@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2014-05-12 23:19:22 Re: pgsql: Replace SYSTEMQUOTEs with Windows-specific wrapper functions.
Previous Message Tom Lane 2014-05-12 18:25:00 pgsql: Ignore config.pl and buildenv.pl in src/tools/msvc.