On Monday, April 20, 2020, John Muehlhausen <jgm(at)jgm(dot)org> wrote:
>
> # docs seem to indicate that an implied transaction
> # will not exist if there is an explicit begin/commit?
> cur.execute(("notify __test; "
> "begin; select pg_advisory_lock(7777); "
> "select pg_advisory_unlock(7777); commit"))
>
>
A more comprehensive reading of the docs finds:
“ If the BEGIN follows some statements that were executed as an implicit
transaction block, those statements are not immediately committed; in
effect, they are retroactively included into the new regular transaction
block. “.
David J.