锁表解锁步骤:
#查询是否有锁表
select relation::regclass, * from pg_locks where not granted;
#查询锁表的oid
select oid from pg_class where relname='可能锁表了的表'
#查询锁表的pid
select pid from pg_locks where relation='上面查出的oid'
#释放锁定的表
select pg_cancel_backend(上面查到的pid)
锁表解锁步骤:
#查询是否有锁表
select relation::regclass, * from pg_locks where not granted;
#查询锁表的oid
select oid from pg_class where relname='可能锁表了的表'
#查询锁表的pid
select pid from pg_locks where relation='上面查出的oid'
#释放锁定的表
select pg_cancel_backend(上面查到的pid)