> >> b...@yugabyte.com wrote:
> >>
> >> I’ve no idea how I might have found this without human help.
> >
> > x...@thebuild.com wrote:
> >
> > That sounds like an excellent documentation patch!
>
> Well, it’s already documented clearly enough. The question is how to find
> it—especially if you
>> b...@yugabyte.com wrote:
>>
>> I’ve no idea how I might have found this without human help.
>
> x...@thebuild.com wrote:
>
> That sounds like an excellent documentation patch!
Well, it’s already documented clearly enough. The question is how to find
it—especially if you don’t know that the
> On Feb 20, 2023, at 17:54, Bryn Llewellyn wrote:
>
>
> I’ve no idea how I might have found this without human help.
That sounds like an excellent documentation patch!
>> b...@yugabyte.com wrote:
>>
>> It seems a bit odd that psql has no syntax to ask for this in its
>> interactive mode.
>
> dan...@manitou-mail.org wrote:
>
> Backslash-semicolon is the syntax.
Thanks, Daniel. Yes, that works. And the server’s SQL statement log confirms
this.
I’ve no idea
Bryn Llewellyn wrote:
> 2023-02-20 12:42:44.993 PST [2540504] d0$u0@d0 LOG: 0: statement:
> insert into s.t(v) values(17); insert into s.t(v) values(42);
> 2023-02-20 12:42:44.993 PST [2540504] d0$u0@d0 LOCATION: exec_simple_query,
> postgres.c:971
>
> It seems a bit odd that psql h
> x...@thebuild.com wrote:
>
>> b...@yugabyte.com wrote:
>>
>> 2. If I send over "begin" and then "insert into s.t(v) values(42)", then (so
>> far) a second session will not see the effect of my SQL's. It sees this only
>> when I send over "commit". (If I send over "rollback" instead of "commit
On Mon, Feb 20, 2023 at 12:57 PM Bryn Llewellyn wrote:
> 3. Chapter 55 also has a section "Multiple Statements In A Simple Query".
> But this feature seems to do no more semantically beyond implicitly
> achieving what I could do by surrounding several statements explicitly with
> "begin; ... comm
> On Feb 20, 2023, at 11:57, Bryn Llewellyn wrote:
> 2. If I send over "begin" and then "insert into s.t(v) values(42)", then (so
> far) a second session will not see the effect of my SQL's. It sees this only
> when I send over "commit". (If I send over "rollback" instead of "commit",
> then
> b...@yugabyte.com wrote:
>
> ...it's not clear who actually implements the opening "start transaction"
> and the closing "commit" around every submitted SQL statement when
> autocommit is "on". Is this done in client-side code (maybe implying
> three round trips per in
