Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY
Дата
Msg-id
20767.1353008153@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
WIP patch: add (PRE|POST)PROCESSOR options to COPY "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Pavel Stehule <pavel.stehule@gmail.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Craig Ringer <ringerc@ringerc.id.au>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Fujii Masao <masao.fujii@gmail.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Simon Riggs <simon@2ndQuadrant.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Craig Ringer <craig@2ndQuadrant.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Craig Ringer <craig@2ndQuadrant.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Robert Haas <robertmhaas@gmail.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Craig Ringer <craig@2ndQuadrant.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Robert Haas <robertmhaas@gmail.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Simon Riggs <simon@2ndQuadrant.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Andrew Dunstan <andrew@dunslane.net>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Andrew Dunstan <andrew@dunslane.net>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Andrew Dunstan <andrew@dunslane.net>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Peter Eisentraut <peter_e@gmx.net>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Andrew Dunstan <andrew@dunslane.net>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Andrew Dunstan <andrew@dunslane.net>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Simon Riggs <simon@2ndQuadrant.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Fujii Masao <masao.fujii@gmail.com>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Andrew Dunstan <andrew@dunslane.net>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Simon Riggs <simon@2ndQuadrant.com>
Robert Haas  writes:
> Yeah.  If we're going to do this at all, and I'm not convinced it's
> worth the work, I think it's definitely good to support a variant
> where we specify exactly the things that will be passed to exec().
> There's just too many ways to accidentally shoot yourself in the foot
> otherwise.  If we want to have an option that lets people shoot
> themselves in the foot, that's fine.  But I think we'd be smart not to
> make that the only option.

[ shrug... ]  Once again, that will turn this from a ten-line patch
into hundreds of lines (and some more, different, hundreds of lines
for Windows I bet), with a corresponding growth in the opportunities
for bugs, for a benefit that's at best debatable.

The biggest problem this patch has had from the very beginning is
overdesign, and this is more of the same.  Let's please just define the
feature as "popen, not fopen, the given string" and have done.  You can
put all the warning verbiage you want in the documentation.  (But note
that the server-side version would be superuser-only in any flavor of
the feature.)
		regards, tom lane


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: pg_ctl reload -o "...."
От: Peter Geoghegan
Дата:
FAQ