Killing process through of a function - Mailing list pgsql-general

From alexandre::aldeia digital
Subject Killing process through of a function
Date
Msg-id 42148A97.7080901@aldeiadigital.com.br
Whole thread Raw
Responses Re: Killing process through of a function
List pgsql-general
Hi,


Can I kill a postgres user process inside a function (SP)?

Sometimes, the java program that our company uses stay in "idle in
transaction" and every day, I need to import a text data to some tables
in DB.
This import make a TRUNCATE in this tables and I need to kill the
remaining process before execute this, to avoid the lock wait.

Thanks for any help


Alexandre de Arruda Paes

pgsql-general by date:

Previous
From: Markus Schaber
Date:
Subject: Re: [postgis-users] postgresql8.0 and postgis1.0.0
Next
From: Bo Lorentsen
Date:
Subject: Deadlock and FK triggers