On Thu, Nov 30, 2017 at 10:40 AM, Peter J. Holzer <hjp-pgsql(at)hjp(dot)at> wrote:
>
> By default psql enables autocommit which causes an implicit commit after
> every statement. With a do block I'm not sure whether that means after
> the do block or after each statement within the do block. I'd just turn
> autocommit off and add explicit commits wherever I wanted them.
A DO block's contents is a single text literal (i.e., data, not SQL) as
far as psql is concerned - the atomic SQL command is the entire DO...END
construct.
David J.