/ blogMon 22 Mar 2021 15:15:41
@dave_cramer @PostgreSQL It looks like a discrepancy, but I believe what's happening is it opens an implicit tx for your -c statement, inside that transaction is a rollback for a transaction that is not in progress, causing the implicit transaction to rollback. In psql, the INSERT is its own implicit tx.
(Originally on Twitter: Mon Mar 22 15:15:41 +0000 2021)