Re: proposal: multiple psql option -c

2015-07-25 10:33 GMT+02:00 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>:

> On Saturday, July 25, 2015, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>>
>> 2015-07-23 17:52 GMT+02:00 Robert Haas <robertmhaas(at)gmail(dot)com>:
>>
>>> On Fri, Jul 17, 2015 at 12:36 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
>>> wrote:
>>> >> Or just properly understand the ; ?
>>> >>
>>> >> -c "select * from foo; update bar set baz = 'bing'; vacuum bar;"
>>> >
>>> > there is a risk of compatibility issues - all statements runs under one
>>> > transaction implicitly
>>>
>>> So what?
>>>
>>
>> [pavel(at)dhcppc2 ~]$ psql -c "insert into x
>> values(txid_current()::text);insert into x values(txid_current()::text)"
>> postgres
>> INSERT 0 1
>> the state string "INSERT 0 1" is buggy probably
>>
>
> How do you figure? The last statement only inserted one record.
>

I understand now, it consistent with current design. So from this view it
is not error.

>
> To that point would you expect each separate -c to output its results to
> the console?
>

It will be nice side effect, but my primary problem was a impossibility to
combine VACUUM and any other statement to one simple psql call.

Pavel

> David J.
>