创建测试数据
drop table if exists json_test;
create table json_test as
select
111 as id,
{"nodes":{"1692328028076":{"nodeId":"1692328028076","nodeName":"测试表1","nodeType":"DATACO…
一旦修改数据就回卡死。 selectpid
frompg_locks
right join (select oid from pg_class where relname表名) t1
on relation t1.oid; --查询出结果则被锁--解锁select pg_cancel_backend(上面查到的pid)上面如果删除不掉那个进程,可以用下面的方式删除
selec…