반품
-
제목
Simple query shows as being held in an 'idle in transaction' state -
설명
When running a simple select query, Toad is causing another query on the same table to wait due to a LOCK on the table - 'idle in transaction' . Hitting the Commit or Rollback buttons, releases the lock. -
해결 방안
WORKAROUND
Click COMMIT or ROLLBACK button to release the lock
STATUS
Rejected: Behavior is the same in psql client:
See https://www.postgresql.org/docs/current/sql-start-transaction.htmlIt states:"In the standard, it is not necessary to issue START TRANSACTION to start a transaction block: any SQL command implicitly begins a block." -
결함 ID
TE-14289