Postgres Pro
Downloads
Home   >   mailing lists

Re: Infinite Loop - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Infinite Loop
Date
Msg-id web-2023206@davinci.ethosmedia.com
Whole thread Raw
In response to Infinite Loop  ("Mark Wilson" <mark@mediasculpt.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Aarni Ruuhimäki
Date:
Subject: Fwd: Re: database location problems
Next
From: "Josh Berkus"
Date:
Subject: Re: Test to see if currval will fail?