Killing process through of a function

["alexandre::aldeia digital" <alepaes@xxxxxxxxxxxxxxxxxxxx>]

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org