From b5b9e33564b453c6c15495b8eb93d988a22cdf3c Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 24 Jun 2004 19:57:14 +0000 Subject: [PATCH] Add documentation for pg_cancel_backend and pg_terminate_backend. Magnus Hagander --- doc/src/sgml/func.sgml | 56 +++++++++++++++++++++++++++++++++++++++++- 1 file changed, 55 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 3de1adafc9..106c4cf775 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ @@ -7406,6 +7406,60 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); columns do not have OIDs of their own. + + pg_cancel_backend + + + + pg_terminate_backend + + + + signal + backend processes + + + + The functions shown in send control signals to + other server processes. Use of these functions is restricted + to superusers. + + + + Backend Signalling Functions + + + Name Return Type Description + + + + + + + pg_cancel_backend(pid) + + int + Cancel a backend's current query + + + + pg_terminate_backend(pid) + + int + Terminate a backend process + + + +
+ + + These functions return 1 if successful, 0 if not successful. + The process ID (pid) of an active backend can be found + from the procpid column in the + pg_stat_activity view, or by listing the postgres + processes on the server. + -- 2.40.0