Re: Cursor fetch Problem.

From: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
To: "'Harry'" <shirlekar(dot)harshal(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cursor fetch Problem.
Date: 2012-12-27 09:48:22
Message-ID: 001501cde417$4f5d0790$ee1716b0$@kapila@huawei.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday, December 27, 2012 11:51 AM Harry wrote:
> Hi Amit,
> Thanks for Reply.
> Kindly see my below output.
>
> Also, tried to Kill it Firstly by using Cancel Backend and then
> Terminate
> Backend output showing "True" but still remaining as a process (i.e. in
> pg_stat_activity).

Can you check the server log and see if there is any of below the statements
in the log:

FATAL: terminating connection due to administrator command
ERROR: canceling statement due to user request

With Regards,
Amit Kapila.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kirk Wythers 2012-12-27 14:54:04 update from a csv file?
Previous Message Harry 2012-12-27 09:13:37 Re: Cursor fetch Problem.