Re: can i get ->execute() to timeout?
[email protected] ("Greg Sabino Mullane")
| Newsgroups | perl.dbd.pg |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > Is this a normal behavior for execute? > Is there any built-in way to set a timeout on execute, or to force it > to detect connection errors at the tcp level? (I could use the > eval/alarm trick in the application, but it feels rather unsafe) I'd feel completely safe about eval/alarm, as long as it works reliably on your platform (and it does unless you have something really obscure or ornery). I don't think there is anything you can do to set it to timeout other than an alarm, nor do I think there is a way to detect things at a lower level (as far as DBD::Pg / DBI / libpq / perl is concerned, the traffic is simply held up and will arrive someday). You might also ask on #postgresql on freenode, there are some smart people there who can give a better answer than I can. - -- Greg Sabino Mullane [email protected] PGP Key: 0x14964AC8 200912171647 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAksqpv4ACgkQvJuQZxSWSsjYQQCgggche/Gv0RtYtcvckXEggfZf FYUAn0zacFT4TO1m5GFCYo7lIHTWiPMT =Mfve -----END PGP SIGNATURE-----