Re: Query Editor and SELECT output in transaction

Hello,

I want to test a simple update statement on pgAdmin (4.16 in a docker container).

I'm running this update between BEGIN and ROLLBACK to not alter database content:

BEGIN;
UPDATE ---;
SELECT ---;
ROLLBACK;

But pgAdmin does not print anything in the "Data Output" tab.

Is it a normal behaviour ?

If I remove BEGIN and ROLLBACK, then the SELECT statement is correctly printed.

Best regards,

Yann.