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
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] |
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 |