Re: trigger audit logon

2018-02-21 Thread legrand legrand
Hi, there is no such trigger in Postgres, but maybe what you are searching is here: https://www.pgaudit.org/ Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-docs-f2165602.html

Re: Statements that time out are not considered here

2018-02-21 Thread legrand legrand
Hi, It seems that auto_explain works only with finished statements. I think (to be confirmed) that SQL statements not finished because timed-out, cancelled, killed, or simply errored are not giving any output. It would be nice if that could be change, giving a partial explain analyze as done in

Re: Statements that time out are not considered here

2018-02-21 Thread Salvador Jacinto
0ORORQE NÃO ME FALA O TREDUZIDO EU RESPONDO TUDO EM UMA SÓ VEz Em 21/02/2018 2:36 PM, "PG Doc comments form" escreveu: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.6/static/auto-explain.html > Description: > > It should be

Statements that time out are not considered here

2018-02-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/auto-explain.html Description: It should be noted that if a statement is cancelled because of the statement_timeout setting, auto_explain will not log it, even if statement_timeout

Re: Pltcl install

2018-02-21 Thread David G. Johnston
On Wednesday, February 21, 2018, PG Doc comments form < nore...@postgresql.org> wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.5/static/pltcl-overview.html > Description: > > How can I install pltcl? > Is possible to copy a

Pltcl install

2018-02-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/static/pltcl-overview.html Description: Good morning, I already installed postgreSQL v:9.5 on my PC and I want to install pltcl language to write external procedure that are used to copy