> 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@xxxxxxxxxx> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
