戻る
-
タイトル
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." -
Defect ID
TE-14289