On Saturday, July 25, 2015, Pavel Stehule <pavel.steh...@gmail.com> wrote: > > 2015-07-23 17:52 GMT+02:00 Robert Haas <robertmh...@gmail.com>: > >> On Fri, Jul 17, 2015 at 12:36 AM, Pavel Stehule <pavel.steh...@gmail.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@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. To that point would you expect each separate -c to output its results to the console? David J.
