Re: BUG #9074: prepared_xacts test freezes

On 2/3/2014 7:31 AM, Tom Lane wrote:
> marco(dot)atzeri(at)gmail(dot)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