session detect and terminate

From: Jie Liang <jliang(at)ipinc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: pgsql-sql(at)postgresql(dot)org
Subject: session detect and terminate
Date: 2001-06-27 06:57:06
Message-ID: Pine.BSF.4.10.10106262341250.91631-100000@tidal.ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql


Hi,

Does postgresql has a way to detect a lock, like Oracle:
update ...... nowait????
Does postgres(or dba) has a privalege to kill a user session inside
the database, like Oracle: kill session.

I believe they are very useful, I have a web based java application
communicate with postgresql via jdbc.
sometime the application will be unexpectly crashed, but the connection
with database is still exist even I close all IE windows. With dead
application open another window often cause trouble.
using unix command 'kill' is not a good solution, so I 'd like find a way
to detect user's session when loading application, and kill the residual
dead session.

thanks.


Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.stbernard.com
www.ipinc.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Huxton 2001-06-27 07:17:38 Re: Using the extract() function in plpgsql
Previous Message Gunnar Rønning 2001-06-27 06:52:26 Re: Re: [ADMIN] High memory usage [PATCH]

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2001-06-27 07:17:38 Re: Using the extract() function in plpgsql
Previous Message Craig Longman 2001-06-27 05:45:35 Re: strange plan