匿名用户relation::regclass没有生效,为啥?
Select locktype,relation::regclass as rel,page||','||tuple as ctid,virtualxid as vxid,transactionid as xid,virtualtransaction as vxid2,pid,mode,granted
From pg_locks
Where pid=4282;
locktype | rel | ctid | vxid | xid | vxid2 | pid | mode | granted
---------------+--------+------+-------+------+-------+------+---------------+---------
relation | 178052 | | | | 7/110 | 4282 | RowShareLock | t
relation | 178046 | | | | 7/110 | 4282 | RowShareLock | t
virtualxid | | | 7/110 | | 7/110 | 4282 | ExclusiveLock | t
transactionid | | | | 1526 | 7/110 | 4282 | ExclusiveLock | t
relation::regclass as rel ,应该把oid转成表名显示,不知道为啥没成功?
我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏


评论
