Thread: Server process

Server process

From

"Michael Ryan S. Puncia"

Date:

25 May 2004, 02:50:20

Hi,

How can I automatically kill a process in the database (ex a select or explain) if it exceeds my limit of 2 or 3 mins ..

For example : I have a query that already running for 3 or 4 mins I want to kill that process for a reason and return a

Signal to the user.

Thanks

Michael

Re: Server process

From

Christopher Kings-Lynne

Date:

25 May 2004, 03:01:15

Read the docs on going SET statement_timeout TO ...;

Chris

Michael Ryan S. Puncia wrote:

>
>
> Hi,
>
>
>
> How can I automatically kill a process in the database (ex a select or
> explain) if it exceeds my limit of 2 or 3 mins ..
>
>  For example : I have a query that already running for 3 or 4 mins I
> want to kill that process for a reason and return a
>
> Signal to the user.
>
>
>
> Thanks
>
> Michael
>