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 file from path to
another.
How can I install pltcl?
Is possible to copy a file from tcl procedure and can this be called from
not SU user?

Thanks,
Thomas


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 file from tcl procedure and can this be called from
> not SU user?
>
>
Your first question is answered on the page you commented on.  I'm not sure
what you mean about the second but pltcl functions execute as the Postgres
(or rather o/s database process) user.

That said, this really isn't intended to be a general help forum.  That is
what our -general mailing list is for.

David J.


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 is greater than auto_explain.log_min_duration .


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 noted that if a statement is cancelled because of the
> statement_timeout setting, auto_explain will not log it, even if
> statement_timeout is greater than auto_explain.log_min_duration .
>


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 

https://github.com/postgrespro/pg_query_state/blob/PGPRO10/runtime_explain.patch

Regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-docs-f2165602.html



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