Re: support for keep alive option

(2014/01/08 18:20), Heikki Linnakangas wrote:
> On 01/08/2014 01:48 AM, Inoue, Hiroshi wrote:
>> Hi Barry,
>>
>> Sorry for the late reply.
>>
>> (2014/01/02 23:02), Barry Bell wrote:
>>> Thanks, Alright with me to add the patch in
>>>
>>> But you may want to Hiroshi (He does the office and unofficial ODBC
>>> driver releases),
>>>
>>> Hiroshi, what do you think of this?
>>
>> OK I would introduce the functionality.
>
> I don't think it should be enabled by default. It's common to expose
> keepalive and other TCP settings as an option, like libpq does, but it's
> not usually enabled by default, and it might be an unwelcome surprise to
> some existing applications.
>
> In particular, if you have a dialup connection, you do *not* want an
> idle connection to keep sending periodic keep-alives, because keeping
> the connection open costs money. It's not as big a problem these days as
> it used to be, but still.

Libpq's keepalives option is on by default. So currently psqlodbc's
keepalive is enabled when libpq is used(in case ssl used etc) otherwise
it is disabled.
Though I am about to enable keepalive by default, I'm not sure which
should be the default.

regards,
Hiroshi Inoue