Toad Data Points creates locks on tables and running select queries in SQL Editor in PostgreSQL database
Connecting to a PostgreSQL 9.4 via ODBC (ODBC Driver 9.03.04) and after running a simple select query in the Editor, the SQL Editor windows maintains a lock on the table(s) involved in the query. Forced to close out Toad Data Point entirely to release the lock.
Defect in View Details Data being opened and used at the time of the SQL query.
Do not use the Details Data tab window when running the SQL. Once tab is opened a lock is created and persists.
Set auto-commit off.
Waiting for a fix in a future release of Toad Data Point.