PostgreSQL Deadlock Problem Resolution record

--Query blocked SQL (deadlock, no SQL executed through) SELECT * from Pg_stat_activity AA, (select A.locktype,a.database,a.pid,a.mode,a.relation,  B.relname from Pg_locks a joins Pg_class B on A.relation=b.oid where upper (b.relname) = ' Fx_wdsj_dszh ') Bbwhere aa.pid=bb.pid and aa.waiting= ' t '--release the deadlock Sqlselect pg_cancel_backend (the PID above)--whether the query locks the table with the select OID from Pg_class where Relname= ' The table '--oid that may have been locked is a idselect pid from pg_locks where relation= ' is hidden by each table--If the result is queried, release the lock select Pg_cancel_backend ( PID as found above)

PostgreSQL Deadlock Problem Resolution record