Re: proposal: multiple psql option -c

2016-02-05 2:35 GMT+01:00 Peter Eisentraut <peter_e(at)gmx(dot)net>:

> On 12/29/15 10:38 AM, Bruce Momjian wrote:
> > On Thu, Dec 10, 2015 at 11:10:55AM -0500, Robert Haas wrote:
> >> On Wed, Dec 9, 2015 at 12:15 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
> >>>> On Wed, Dec 9, 2015 at 2:07 PM, Pavel Stehule <
> pavel(dot)stehule(at)gmail(dot)com>
> >>>> wrote:
> >>>>> should be noted, recorded somewhere so this introduce possible
> >>>>> compatibility
> >>>>> issue - due default processing .psqlrc.
> >>>>
> >>>> That's written in the commit log, so I guess that's fine.
> >>>
> >>> ook
> >>
> >> Bruce uses the commit log to prepare the release notes, so I guess
> >> he'll make mention of this.
> >
> > Yes, I will certainly see it.
>
> I generally use the master branch psql for normal work, and this change
> has caused massive breakage for me. It's straightforward to fix, but in
> some cases the breakage is silent, for example if you do
> something=$(psql -c ...) and the .psqlrc processing causes additional
> output. I'm not sure what to make of it yet, but I want to mention it,
> because I fear there will be heartache.
>

We can still introduce some system environment, that disable psqlrc globally

PGNOPSQLRC=1 psql ...

Regards

Pavel