Re: pg_stat_statements : how to catch non successfully finishedstatements ?

Поиск
Список
Период
Сортировка
От legrand legrand
Тема Re: pg_stat_statements : how to catch non successfully finishedstatements ?
Дата
Msg-id 1524946656214-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: pg_stat_statements : how to catch non successfully finishedstatements ?  (Arthur Zakirov <a.zakirov@postgrespro.ru>)
Ответы Re: pg_stat_statements : how to catch non successfully finished statements ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
OK I see ...

This hook should be used only for ERROR (no WARNING nor NOTICE ...)
and the only real interesting information is  
  ErrorData -> internalquery; /* text of internally-generated query */

This doesn't permit to (re)build the link to queryid 
(that is based on parse tree, but not available here)

So the only solution is to had queryId to ErrorData in this hook
or create a new hook fired on ERROR and containing queryId ?

Regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


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

Предыдущее
От: "g@luxsci.net"
Дата:
Сообщение: Re: Rationale for aversion to the central database?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_stat_statements : how to catch non successfully finished statements ?