Thread: how to kill postgreSQL session

Hi there,
 
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));

}

 

---

Discover the new Windows Vista Learn more!

> 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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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