Even better. Thanks =).
On Sat, 21 Aug 2004 20:14:53 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>
> Vitaly Belman <vitalyb@gmail.com> writes:
> > Is there a way to kill a session in PostrgeSQL? I ran a bad query by
> > mistake and I don't want to shut the whole database just to quit using
> > the whole CPU.
>
> ISTM what you really want is query cancel, not whole-session kill.
> Try "kill -INT <pid-of-backend>".
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>
--
ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent@hotmail.com
Yahoo!: VitalyBe