"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Friday, November 20, 2020, Srinivasa T N <seenutn@gmail.com> wrote:
>> 2020-11-20 11:20:46.218 IST [38207] LOG: execute S_3: ROLLBACK
> If there was an error you would see an error message. Plus, PostgreSQL
> doesn’t just internally issue a rollback on its own. That said I’m not
> sure what is being shown, or rather where the “execute” stuff comes from.
The "execute" says this is an execution of a previously prepared query,
ie the client is using extended query protocol rather than simple.
It's got nothing much to do with the semantics though. It seems clear
that the client chose to roll back the transaction; the server did not
do that.
regards, tom lane