Killing process through of a function

From: "alexandre::aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Killing process through of a function
Date: 2005-02-17 12:14:15
Message-ID: 42148A97.7080901@aldeiadigital.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bo Lorentsen 2005-02-17 12:16:11 Deadlock and FK triggers
Previous Message Markus Schaber 2005-02-17 11:26:12 Re: [postgis-users] postgresql8.0 and postgis1.0.0