Jakub Ouhrabka <kuba(at)comgate(dot)cz> writes:
> So if I understand it correctly, if I need correct transaction behaviour
> in psql even in case of disconnection the only safe way is to use one
> statement per line.
In existing releases, yes. Having put the BEGIN and UPDATE all on one
line was a necessary precondition for this problem.
regards, tom lane