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

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