Killing process through of a function - Mailing 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