[BUGS] BUG #14617: Stetement terminator stored in pg_stat_statements

Поиск
Список
Период
Сортировка
От buschmann@nidsa.net
Тема [BUGS] BUG #14617: Stetement terminator stored in pg_stat_statements
Дата
Msg-id 20170410145702.25934.20733@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14617: Stetement terminator stored in pg_stat_statements  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14617
Logged by:          Hans Buschmann
Email address:      buschmann@nidsa.net
PostgreSQL version: 9.6.2
Operating system:   Windows x64
Description:

I recently observed that the statement terminator (the semicolon) is stored
as part of the query column in pg_stat_tables.

When used programmatically (from Web application) the same statement has no
query separator and generates a separate entry in pg_stat_statements.
I observed it with a query like:

refresh materialized view my_mat_view;

which occurred twice when used interactively and by the program.

In my opinion the semicolon should be strapped before normalizing the query
for entry into pg_stat_statements.


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: balazs@obiserver.hu
Дата:
Сообщение: [BUGS] BUG #14616: error message without schema
Следующее
От: julien.vacassoulis@gmail.com
Дата:
Сообщение: [BUGS] BUG #14618: pg_repack - waiting for 1 transactions to finish