Re: [HACKERS] dblink doesn't honor interrupts while waiting a result

2008-03-06 Thread Decibel!
On Mon, Feb 25, 2008 at 04:45:43AM +0100, Florian G. Pflug wrote: dblink in 8.3 blocks without any possibility of interrupting it while waiting for an answer from the remote server. Here is a strace [pid 27607] rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_IGN}, 8) = 0 [pid 27607] sendto(56,

Re: [HACKERS] dblink doesn't honor interrupts while waiting a result

2008-02-25 Thread Marko Kreen
On 2/25/08, Florian G. Pflug [EMAIL PROTECTED] wrote: I'm not sure how a proper fix for this could look like, since the blocking actually happens inside libpq - but this certainly makes working with dblink painfull... Proper fix would be to use async libpq API, then loop on poll(2) with

Re: [HACKERS] dblink doesn't honor interrupts while waiting a result

2008-02-25 Thread Florian G. Pflug
Marko Kreen wrote: On 2/25/08, Florian G. Pflug [EMAIL PROTECTED] wrote: I'm not sure how a proper fix for this could look like, since the blocking actually happens inside libpq - but this certainly makes working with dblink painfull... Proper fix would be to use async libpq API, then loop

[HACKERS] dblink doesn't honor interrupts while waiting a result

2008-02-24 Thread Florian G. Pflug
Hi dblink in 8.3 blocks without any possibility of interrupting it while waiting for an answer from the remote server. Here is a strace [pid 27607] rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_IGN}, 8) = 0 [pid 27607] sendto(56, Q\0\0\0008lock table travelhit.booking_code in exclusive mode\0, 57, 0,