Rollback and commit button gets activated for sometime on getting any error for SQL query or cancelling the query.

[anilsahoo20]

Please note that security bugs or issues should be reported to security@pgadmin.org.

Describe the bug

If we run some query and the some error occurs or if we cancel the query in between, the rollback and commit button gets activated for some seconds.

To Reproduce

Steps to reproduce the behavior:

1. Open query tool
2. Run any wrong query
3. See the rollback and commit button gets activated for some seconds

Expected behavior

These buttons should not get activated.

Desktop (please complete the following information):

• OS: [e.g. Windows 10, OSX monterey]
• Version: [e.g. 6.15]
• Mode: [e.g Desktop or Server]
• Browser (if running in server mode): [e.g. chrome, safari]
• Package type: [e.g. RPM, DEB, Python, Container, etc.]

Additional context

Add any other context about the problem here.

[JyotiEdb]

@anilsahoo20
All working fine,
But when we run wrong query and auto-commit is off, we get error, and after clicking commit button its shows massage of rollback, is it expected behaviour?

[anilsahoo20]

@JyotiEdb,
yes it is correct behaviour. Because there is nothing to commit as the error comes in. so the commit and rollback button will rollback always.

[JyotiEdb]

Tested and verified on snapshot build:
https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2024-03-28/