Re: BUG #9074: prepared_xacts test freezes - Mailing list pgsql-bugs

On 2/3/2014 7:31 AM, Tom Lane wrote:
> marco.atzeri@gmail.com writes:
>> going step by step, the freezing point is:
>
>> -- pxtest3 should be locked because of the pending DROP
>> set statement_timeout to 2000;
>> SELECT * FROM pxtest3;
>> instead of
>> --------------------------------
>> ERROR:  canceling statement due to statement timeout
>> -----------------------------------
>> the SELECT never returns.
>
> Something broken in SIGALRM signal handling, seems like.  But in this
> case, the code *does* work on older Cygwin versions, so I think it's
> incumbent on you to figure out why newer Cygwin is failing.
>
>             regards, tom lane

for the archives, the cygwin bug was identified and solved.

postgresql-9.4.0

      prepared_xacts           ... ok

Regards
Marco