Even better. Thanks =). On Sat, 21 Aug 2004 20:14:53 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > > > Vitaly Belman <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] Yahoo!: VitalyBe ---------------------------(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