Query Editor and SELECT output in transaction

From: Yann Papouin <y(dot)papouin(at)dec-industrie(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Query Editor and SELECT output in transaction
Date: 2020-03-30 22:57:23
Message-ID: CAFtnWX25JMawY+XnDKoVur97CcZruo9gRzSnqRNabZkr4EKXYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message J Paz 2020-03-31 06:16:47 RE: ASC files not verifying Windows pgAdmin 4 installers
Previous Message Dave Page 2020-03-30 08:18:08 Re: ASC files not verifying Windows pgAdmin 4 installers