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));
}
#endif
_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
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. +