[GENERAL] Running OS-level programs from Postgres?

2007-06-20 Thread Sean Murphy
Maybe this is a well duh kind of question, or maybe there's no straightforward way to do it, but is there any way that I could have a pg function initiate a process on the host system? Specifically I'd like to script an email to send off on an insert trigger, but the ability to initiate system pro

[GENERAL] Idle session timeout?

2007-05-08 Thread Sean Murphy
I've got a bunch of users on VB applications connecting to PG 8.2.3 via psqlodbc with SSL. For a variety of reasons, some good, some probably bad, I have the app open a connection and leave it open, using it as needed to run queries back and forth. If I look in my logs, I see loans of little clust

Re: [GENERAL] Idle session timeout?

2007-05-08 Thread Sean Murphy
Tom Lane wrote: > Sean Murphy <[EMAIL PROTECTED]> writes: >> I'm WAY out of my depth here, but my impression, based on the >> circumstances, is that there is some sort of an idle session timeout >> kicking in (most likely on the client side) and dropping the

Re: [GENERAL] Idle session timeout?

2007-05-08 Thread Sean Murphy
Scott Marlowe wrote: > On Tue, 2007-05-08 at 12:19, Sean Murphy wrote: >> Tom Lane wrote: >>> Sean Murphy <[EMAIL PROTECTED]> writes: >>>> I'm WAY out of my depth here, but my impression, based on the >>>> circumstances, is that there is some

Re: [GENERAL] Idle session timeout?

2007-05-08 Thread Sean Murphy
Scott Marlowe wrote: > On Tue, 2007-05-08 at 15:59, Sean Murphy wrote: >> Scott Marlowe wrote: >>> On Tue, 2007-05-08 at 12:19, Sean Murphy wrote: >>>> Tom Lane wrote: >>>>> Sean Murphy <[EMAIL PROTECTED]> writes: >>>>&