细节
-
错误
-
状态: Done">完成
-
媒介
-
解决方法: 完成
-
Pg_sm - 1.0.1
-
没有一个
-
是的
-
是的
-
团队冲刺5
-
是的
-
是的
描述
在使用pg_stat_monitor时。raybet雷竞技竞猜在线官网pgsm_extract_comments = 'no',这是PGSM中的默认行为,注释仍在提取。
这个行为在分支'main'和REL_1_STABLE上都可见,在标签'1.0.1'上也可见。看起来,这需要代码修复和回归更新。DEV需要看一下。
国防部:
设置pg_stat_raybet雷竞技竞猜在线官网monitor。Pgsm_extract_comments = 'no'(也是默认行为),对于任何有注释的查询都不应该可见注释。
设置pg_stat_raybet雷竞技竞猜在线官网monitor。Pgsm_extract_comments = 'yes',注释对于任何有注释的查询都应该是可见的。
(电子邮件保护)~/pg_stat_mraybet雷竞技竞猜在线官网onitor$ sudo systemctl restart .输出说明(电子邮件保护)(电子邮件保护):~/pg_stat_raybet雷竞技竞猜在线官网monitor$ psql psql (14.3 (Ubuntu 14.3-1.pgdg20.04+1)“帮助”为的帮助。Postgres =# drop extension pg_statraybet雷竞技竞猜在线官网_monitorDROP EXTENSION postgres=# create EXTENSION pg_stat_raybet雷竞技竞猜在线官网monitor;CREATE EXTENSION postgres=# SELECT pg_stat_raybet雷竞技竞猜在线官网monitor_reset();pg_stat_raybet雷竞技竞猜在线官网monitor_reset ----------------------- ( 1行)postgres = # SELECT * from pg_stat_monitor_settings name =“pg_stat_raybet雷竞技竞猜在线官网monitor.pgsm_extract_comments”;名称|值| default_value | | |最小需求描述最大| |选项重新启动 ---------------------------------------+-------+---------------+--------------------------------------------------+---------+---------+---------+--------- pg_stat_monitor。raybet雷竞技竞猜在线官网pgsm_extract_comments | no | no |启用/禁用从查询中提取注释。| | | yes, no | no (1 row) postgres=# SELECT 1 AS num/*第一条评论*/,“约翰。”一样的名字/*第二条评论*/;num | name -----+------ 1 | John(1行)postgres=# SELECT查询,comments FROM pg_stat_monitor ORraybet雷竞技竞猜在线官网DER BY查询COLLATE“C”;查询|评论 ------------------------------------------------------------------------+------------------------------------------ 选择1美元作为num/*第一条评论*/,名称为2美元/*第二条评论*/|/*第一条评论*/,/*第二条评论*/SELECT * from pg_stat_raybet雷竞技竞猜在线官网monitor_settings where name=$1 | SELECT pg_stat_monitor_reset() | SELECT查询,comments from pg_stat_monitor ORDER BY查询COLLATE“C”|(4行)postgres=# \q(电子邮件保护)~/pg_stat_mraybet雷竞技竞猜在线官网onitor$ vim /etc/postgresql/14/main/postgresql.conf(电子邮件保护)~/pg_stat_mraybet雷竞技竞猜在线官网onitor$ sudo systemctl restart .输出说明(电子邮件保护)(电子邮件保护):~/pg_stat_raybet雷竞技竞猜在线官网monitor$ psql psql (14.3 (Ubuntu 14.3-1.pgdg20.04+1)“帮助”为的帮助。Postgres =# drop extension pg_statraybet雷竞技竞猜在线官网_monitorDROP EXTENSION postgres=# create EXTENSION pg_stat_raybet雷竞技竞猜在线官网monitor;CREATE EXTENSION postgres=# SELECT pg_stat_raybet雷竞技竞猜在线官网monitor_reset();pg_stat_raybet雷竞技竞猜在线官网monitor_reset ----------------------- ( 1行)postgres = # SELECT * from pg_stat_monitor_settings name =“pg_stat_raybet雷竞技竞猜在线官网monitor.pgsm_extract_comments”;名称|值| default_value | | |最小需求描述最大| |选项重新启动 ---------------------------------------+-------+---------------+--------------------------------------------------+---------+---------+---------+--------- pg_stat_monitor。raybet雷竞技竞猜在线官网pgsm_extract_comments | yes | no |启用/禁用从查询中提取注释。| | | yes, no | no (1 row) postgres=# SELECT 1 AS num/*第一条评论*/,“约翰。”一样的名字/*第二条评论*/;num | name -----+------ 1 | John(1行)postgres=# SELECT查询,comments FROM pg_stat_monitor ORraybet雷竞技竞猜在线官网DER BY查询COLLATE“C”;查询|评论 ------------------------------------------------------------------------+------------------------------------------ 选择1美元作为num/*第一条评论*/,名称为2美元/*第二条评论*/|/*第一条评论*/,/*第二条评论*/SELECT * from pg_stat_raybet雷竞技竞猜在线官网monitor_settings where name=$1 | SELECT pg_stat_monitor_reset() | SELECT查询,comments from pg_stat_monitor ORDER BY查询COLLATE“C”|(4行)postgres=# SELECT pg_stat_monitoraybet雷竞技竞猜在线官网r_version();pg_stat_raybet雷竞技竞猜在线官网monitor_version ------------------------- 1.0.1(1行)postgres = # \问(电子邮件保护)~/pg_stat_mraybet雷竞技竞猜在线官网onitor$ vim /etc/postgresql/14/main/postgresql.conf(电子邮件保护)~/pg_stat_mraybet雷竞技竞猜在线官网onitor$ sudo systemctl restart .输出说明(电子邮件保护)(电子邮件保护):~/pg_stat_raybet雷竞技竞猜在线官网monitor$ psql psql (14.3 (Ubuntu 14.3-1.pgdg20.04+1)“帮助”为的帮助。Postgres =# drop extension pg_statraybet雷竞技竞猜在线官网_monitorDROP EXTENSION postgres=# create EXTENSION pg_stat_raybet雷竞技竞猜在线官网monitor;CREATE EXTENSION postgres=# SELECT pg_stat_raybet雷竞技竞猜在线官网monitor_reset();pg_stat_raybet雷竞技竞猜在线官网monitor_reset ----------------------- ( 1行)postgres = # SELECT * from pg_stat_monitor_settings name =“pg_stat_raybet雷竞技竞猜在线官网monitor.pgsm_extract_comments”;名称|值| default_value | | |最小需求描述最大| |选项重新启动 ---------------------------------------+-------+---------------+--------------------------------------------------+---------+---------+---------+--------- pg_stat_monitor。raybet雷竞技竞猜在线官网pgsm_extract_comments | no | no |启用/禁用从查询中提取注释。| | | yes, no | no (1 row) postgres=# SELECT 1 AS num/*第一条评论*/,“约翰。”一样的名字/*第二条评论*/;num | name -----+------ 1 | John(1行)postgres=# SELECT查询,comments FROM pg_stat_monitor ORraybet雷竞技竞猜在线官网DER BY查询COLLATE“C”;查询|评论 ------------------------------------------------------------------------+------------------------------------------ 选择1美元作为num/*第一条评论*/,名称为2美元/*第二条评论*/|/*第一条评论*/,/*第二条评论*/SELECT * from pg_stat_raybet雷竞技竞猜在线官网monitor_settings where name=$1 | SELECT pg_stat_monitor_reset() | SELECT查询,comments from pg_stat_monitor ORDER BY查询COLLATE“C”|(4行)