Thread: Infinite Loop

Infinite Loop

From
"Mark Wilson"
Date:
I've been bad.  You'll smack me.
 
I wrote a plpgsql function with an infinite loop in it.  I have executed said function.
 
How can I track down and kill this session? (v7.2.1)
 
Mark

Re: Infinite Loop

From
"Josh Berkus"
Date:
Mark,

> I wrote a plpgsql function with an infinite loop in it.  I have
> executed said function.
>
> How can I track down and kill this session? (v7.2.1)

I'd suggest doing a "pg_ctl -m fast stop" to halt the database, then
restarting.

-Josh Berkus

Re: Infinite Loop

From
"Mark Wilson"
Date:
Thanks Josh

----- Original Message -----
From: "Josh Berkus" <josh@agliodbs.com>
To: "Mark Wilson" <mark@mediasculpt.com>
Cc: <pgsql-novice@postgresql.org>
Sent: Friday, December 06, 2002 11:54 AM
Subject: Re: [NOVICE] Infinite Loop


> Mark,
>
> > I wrote a plpgsql function with an infinite loop in it.  I have
> > executed said function.
> >
> > How can I track down and kill this session? (v7.2.1)
>
> I'd suggest doing a "pg_ctl -m fast stop" to halt the database, then
> restarting.
>
> -Josh Berkus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>