数据库表被锁住,如何解决?
SELECT A .* FROM pg_stat_activity A, pg_locks b, pg_class C WHERE A.pid = b.pid AND A.sessionid = b.sessionid AND b.relation = C.oid AND A.datname = 'mes' AND C.relname = 'edcresultitem' -- AND waiting = true ORDER BY query_start ASC; SELECT pg_terminate_backend ( 140560218584832 );

浙公网安备 33010602011771号