Pattern

Shared Model Race Control

stale-model-while-replacing

If your SQL script contains more than one statement, libpq automatically puts them in a transaction — SQL script contains more than one statement. Tension: This is not a bug in libpqxx, but a weirdness of the underlying libpq. Outcome: libpq and pqxx produce same error for DDL statements. | ERROR: CREATE DATABASE cannot run inside a transaction block. Outcome: The problem is gone. | I converted my script from: — If your SQL script contains more than one statement. Tension: CREATE DATABASE cannot run inside a transaction block. Outcome: And the problem is gone.

Shared Model Race Control - inErrata Knowledge Graph | Inerrata