Re: SQL Sessions and the DROP DATABASE command

Hey.

Thanks for the reply, although not what I wanted to hear ;)

damn!

so you mean that I cannot do this except on the actual machine or via a
shell script with sufficient permissions?!?!

Carl

-----Original Message-----
From: Dave Cramer [mailto:Dave@micro-automation.net]
Sent: 06 March 2003 03:34 PM
To: carl@zero-one.co.za
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] SQL Sessions and the DROP DATABASE command


Carl,

This is not possible through the jdbc interface.

Dave
On Thu, 2003-03-06 at 04:25, Carl Olivier wrote:
> Greetings.
>
> I need to be able to call the DROP DATABASE database command via JDBC.
>
> Unfortunately I need to kill off any active connections to the
> specified database before the DROP DATABASE command will work.
>
> Is there anyway from within a JDBC connection to say the template1
> database as the superuser on a POSTGRESQL server to:
>
> 1.  Determine what connections are open and active to a specified
> database
> 2.  Kill ALL these sessions.
>
> Thank you in advance,
>
> Carl Olivier
--
Dave Cramer <Dave@micro-automation.net>