Home > mailing lists

Thread: Query Editor and SELECT output in transaction

Query Editor and SELECT output in transaction

From

Yann Papouin

Date:

31 March 2020, 01:57:23

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.

Re: Query Editor and SELECT output in transaction

From

Khushboo Vashi

Date:

01 April 2020, 06:57:03

Hi,

On Tue, Mar 31, 2020 at 7:15 PM Yann Papouin <y.papouin@dec-industrie.com> wrote:

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.

Please report this issue @ https://redmine.postgresql.org/projects/pgadmin4 .

Thanks,

Khushboo

Best regards,
Yann.