//查询是否锁表
select oid from pg_class where relname = ‘可能锁表了的表名’;
select pid from pg_class where relation = ‘上面查出来的oid’;
//如果查询到了结果,表示该表可能被锁了,则需要释放锁定
select pg_cancel_backend();//括号中放上面查询出来的pid
//查询是否锁表
select oid from pg_class where relname = ‘可能锁表了的表名’;
select pid from pg_class where relation = ‘上面查出来的oid’;
//如果查询到了结果,表示该表可能被锁了,则需要释放锁定
select pg_cancel_backend();//括号中放上面查询出来的pid