Re: how to kill postgreSQL session

> I'm a developer who is working on PostgreSQL API and i got stuck in
> Terminating session.
> I'm working on PostgreSQL 8.3.
>
> Please, help if anyone has ideas on how to kill PostgreSQL session.
>
> i found this code in misc.c
>
> #ifdef NOT_USED
>
> /* Disabled in 8.0 due to reliability concerns; FIXME someday */
> Datum
> pg_terminate_backend(PG_FUNCTION_ARGS)
> {
> PG_RETURN_INT32(pg_signal_backend(PG_GETARG_INT32(0),
> SIGTERM));
> }
>
> #endif

There is no supported way of terminating a session in 8.3 bu you can use
query_cancel stop terminate the query. 8.4 will have this capability.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +