Re: Interrupt

Sorry I should have added that I need to do this within ECPG.
Atif

On 13 May 2010 02:47, Mladen Gogala <mgogala(at)vmsinfo(dot)com> wrote:

> Interrupt the server? Well, Monzy sang about that at one time, but
> depending on where are you executing the SQL statement from, SIGINT to the
> front end will usually do the trick. The "init 6" command, executed as user
> "root", should also be able to interrupt the server and the on-going SQL, as
> well as everything else. It's the reboot command.
>
> ----- Original Message -----
> From: "Atif Jung" <atifjung(at)gmail(dot)com>
> To: pgsql-novice(at)postgresql(dot)org
> Sent: Wednesday, May 12, 2010 9:31:09 AM GMT -05:00 US/Canada Eastern
> Subject: [NOVICE] Interrupt
>
>
> How do I interrupt the database server and cancel any SQL statement
> currently running?
>
> Thanks
>
> Atif
>
> --
> Mladen Gogala
> Sr. Oracle DBA
> 1500 Broadway
> New York, NY 10036
> (212) 329-5251
> www.vmsinfo.com
>
>