咨询锁出现下列警告
WARNING: you don't own a lock of type ExclusiveLock
原因:试图释放锁的次数超过锁定的次数。
问题重现:锁定了一次,但释放了两次所以出现“WARNING: you don’t own a lock of type ExclusiveLock”
with cte as(
select pg_advisory_lock(1)
)select pg_advisory_unlock(1),pg_advisory_unlock(1) from cte