Re: proposal: multiple psql option -c

Поиск
Список
Период
Сортировка
Искать
От
David G. Johnston
Тема
Re: proposal: multiple psql option -c
Дата
Msg-id
CAKFQuwZcpyk5UeGcLTpFCPynRbm7nd3VN046cs_Ek0mTD6tETA@mail.gmail.com
Ответ на
Список
Дерево обсуждения
proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Rosser Schwarz <rosser.schwarz@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c dinesh kumar <dineshkumar02@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c "Joshua D. Drake" <jd@commandprompt.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
proposal: multiple psql option -c "David G. Johnston" <david.g.johnston@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Andrew Dunstan <andrew@dunslane.net>
Re: proposal: multiple psql option -c Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Andrew Dunstan <andrew@dunslane.net>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Andrew Dunstan <andrew@dunslane.net>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c "David G. Johnston" <david.g.johnston@gmail.com>
Re: proposal: multiple psql option -c Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c "David G. Johnston" <david.g.johnston@gmail.com>
Re: proposal: multiple psql option -c Adam Brightwell <adam.brightwell@crunchydatasolutions.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Catalin Iacob <iacobcatalin@gmail.com>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Michael Paquier <michael.paquier@gmail.com>
Re: proposal: multiple psql option -c "David G. Johnston" <david.g.johnston@gmail.com>
Re: proposal: multiple psql option -c Michael Paquier <michael.paquier@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Catalin Iacob <iacobcatalin@gmail.com>
Re: proposal: multiple psql option -c Andrew Dunstan <andrew@dunslane.net>
Re: proposal: multiple psql option -c Catalin Iacob <iacobcatalin@gmail.com>
Re: proposal: multiple psql option -c Andrew Dunstan <andrew@dunslane.net>
Re: proposal: multiple psql option -c Peter Eisentraut <peter_e@gmx.net>
Re: proposal: multiple psql option -c Andrew Dunstan <andrew@dunslane.net>
Re: proposal: multiple psql option -c Catalin Iacob <iacobcatalin@gmail.com>
Re: proposal: multiple psql option -c Andrew Dunstan <andrew@dunslane.net>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Tom Lane <tgl@sss.pgh.pa.us>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Tom Lane <tgl@sss.pgh.pa.us>
Re: proposal: multiple psql option -c Andrew Dunstan <andrew@dunslane.net>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Tom Lane <tgl@sss.pgh.pa.us>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Catalin Iacob <iacobcatalin@gmail.com>
Re: proposal: multiple psql option -c Catalin Iacob <iacobcatalin@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Michael Paquier <michael.paquier@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Michael Paquier <michael.paquier@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Catalin Iacob <iacobcatalin@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Michael Paquier <michael.paquier@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Michael Paquier <michael.paquier@gmail.com>
Re: proposal: multiple psql option -c Michael Paquier <michael.paquier@gmail.com>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Michael Paquier <michael.paquier@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Michael Paquier <michael.paquier@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Bruce Momjian <bruce@momjian.us>
Re: proposal: multiple psql option -c Peter Eisentraut <peter_e@gmx.net>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Catalin Iacob <iacobcatalin@gmail.com>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c David Fetter <david@fetter.org>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c "David G. Johnston" <david.g.johnston@gmail.com>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Marc Mamin <M.Mamin@intershop.de>
Re: proposal: multiple psql option -c Andrew Dunstan <andrew@dunslane.net>
Re: proposal: multiple psql option -c Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: multiple psql option -c Marc Mamin <M.Mamin@intershop.de>
Re: proposal: multiple psql option -c Robert Haas <robertmhaas@gmail.com>
Re: proposal: multiple psql option -c Marc Mamin <M.Mamin@intershop.de>
Re: proposal: multiple psql option -c Craig Ringer <craig@2ndquadrant.com>
On Fri, Aug 28, 2015 at 4:18 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:


2015-08-28 22:07 GMT+02:00 Jim Nasby <Jim.Nasby@bluetreble.com>:
On 8/26/15 8:15 AM, Pavel Stehule wrote:
+      and then exit. This is useful in shell scripts. Start-up files
+      (<filename>psqlrc</filename> and <filename>~/.psqlrc</filename>) are
+      ignored with this option.

Sorry if this was discussed and I missed it, but I think this is a bad idea. There's already an option to control this. More important, there's no option to force the rc files to be used, so if -g disables them you'd be stuck with that.

I agree that the rc files are a danger when scripting, but if we want to do something about that then it needs to be consistent for ALL non-interactive use.

I don't see any problem to load rc files - but should I do it by default? I prefer

1. default - don't read rc
2. possible long option for forcing load rc for -c and -g
3. possible long option for forcing load any file as rc for -c and -g


​--psqlrc​
 
​; read the standard rc files​
--no-psqlrc ; do not read the standard rc files

It belongs in a separate patch, though.

In this patch -g should disable the reading of the standard rc files.

Yet another option could be added that allows the user to point to a different set of rc files.  Its presence should not cause the include/exclude behavior to change.  That way you can setup a psql wrapper function or alias that uses a different ​rc file while still having control over whether it is included or excluded.  The problem here is exploding the logic in order to deal with both a system and a user rc file.

This would be yet another patch.

My $0.02

David J.

В списке pgsql-hackers по дате отправления
От: Pavel Stehule
Дата:
От: Tom Lane
Дата:
FAQ