[unixODBC-support] Postgresql driver and query timeout

Stefan Radman Stefan.Radman at CTBTO.ORG
Tue Jul 31 08:05:38 BST 2007


> You could check in the later driver from the Postgres people, 

FYI - the code has not changed
The latest official PostgreSQL ODBC Driver (psqlODBC 08.02.400) ignores
it as well.
http://psqlodbc.projects.postgresql.org/

Stefan 

> -----Original Message-----
> From: unixodbc-support-bounces at easysoft.com 
> [mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of 
> Nick Gorham
> Sent: Tuesday, 31 July, 2007 08:59
> To: Support for the unixODBC project
> Subject: Re: [unixODBC-support] Postgresql driver and query timeout
> 
> Bhagya Prasad wrote:
> 
> >Hi,
> >I am using unixODBC driver for postgresql driver.  From the
> >implementation I found that SQ_QUERY_TIMEOUT is not supported.  Also,
> >tested with SQLSetStmtAttr for time out parameter and is not taking
> >effect.
> >
> >//From unixODBC-2.2.12/Drivers/PostgreSQL/options.c
> >
> >    case SQL_QUERY_TIMEOUT: /* ignored */
> >        mylog("SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 
> %d\n", vParam);
> >        /*//    "0" returned in SQLGetStmtOption */
> >        break;
> >
> >How to get set query timeout working?  Are there any alternatives.
> >  
> >
> Hi,
> 
> You could check in the later driver from the Postgres people, 
> but other 
> than that, the only option would be to try and code it yourself.
> 
> Sorry.
> 
> -- 
> Nick
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> 



More information about the unixODBC-support mailing list