On Thu, Nov 30, 2017 at 10:40 AM, Peter J. Holzer <hjp-pg...@hjp.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.
