postgresql 解锁表语句

xiaoxiao2021-02-28  8

解锁表语句:

select 

a.locktype,

a.database,

a.pid,

a.mode,

a.relation,

a.relname

from

pg_locks a join pg_class b on a.relation = b.oid

where 

b.relname = 'sws_fs_target_kpi_allot_month';

 

select pg_cancel_backend(17962);

转载请注明原文地址: https://www.6miu.com/read-2000046.html

最新回复(0)