Re: psql - -dry-run option

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: psql - -dry-run option
Дата
Msg-id 13653.1450379035@sss.pgh.pa.us
обсуждение исходный текст
Ответ на psql - -dry-run option  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: psql - -dry-run option  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> when I read a blog
> http://www.depesz.com/2015/12/14/waiting-for-9-6-psql-support-multiple-c-and-f-options-and-allow-mixing-them/
> where is emulated dry-run mode, I though so we can implement it very
> simply.

Not one that is actually reliable.  All a script would have to do is
include its own begin/commit commands, and it would override what you
are talking about.  It's okay, in my opinion, if the -1 switch is just a
half-baked "best effort" solution.  It's not okay to provide a --dry-run
switch that is equally full of holes, because if someone were to actually
rely on it to not execute the script, the possibility of an override would
amount to a security bug.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Fwd: Cluster "stuck" in "not accepting commands to avoid wraparound data loss"
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: psql - -dry-run option