On Fri, Feb 18, 2005 at 10:05:25AM -0200, alexandre::aldeia digital wrote:
> IBM DB2 have functions that allow the DBA to disconnect some clients.
> This is very usefull for database maintenance without giving a shell to him.
As I mentioned, you could write a function in C, PL/Perl, etc.,
that s
Hi Michael,
The software was generated by a CASE tool (genexus) and it's does not
permit any modification.
IBM DB2 have functions that allow the DBA to disconnect some clients.
This is very usefull for database maintenance without giving a shell to him.
VACUUM FULL is other "application" thats
On Thu, Feb 17, 2005 at 10:14:15AM -0200, alexandre::aldeia digital wrote:
>
> Can I kill a postgres user process inside a function (SP)?
Functions written in C, PL/Perl, PL/Tcl, etc., can use whatever
facilities those languages provide, such as sending signals to
processes. Whether that's a goo
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 bef
