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
