Re: [GENERAL] Cursor timeout in postgres

2007-02-06 Thread Tom Lane
Tim Tassonis <[EMAIL PROTECTED]> writes: > I try to reproduce the situation tomorrow and will also check on any > odbc_errmsg() messages and the postmaster log. OK. A couple of comments: the only timeout within Postgres itself is statement_timeout, which I think wouldn't apply to your situation

Re: [GENERAL] Cursor timeout in postgres

2007-02-06 Thread Tim Tassonis
Hi Tom Tom Lane wrote: Tim Tassonis <[EMAIL PROTECTED]> writes: When examining strange behaviour in one of my programs I found out that I must have somehow gotten into a timeout situation when fetching rows from a cursor. My program read the first row, did some stuff for six minutes and then

Re: [GENERAL] Cursor timeout in postgres

2007-02-06 Thread Tom Lane
Tim Tassonis <[EMAIL PROTECTED]> writes: > When examining strange behaviour in one of my programs I found out that > I must have somehow gotten into a timeout situation when fetching rows > from a cursor. My program read the first row, did some stuff for six > minutes and then tried to fetch the

[GENERAL] Cursor timeout in postgres

2007-02-06 Thread Tim Tassonis
Hi all When examining strange behaviour in one of my programs I found out that I must have somehow gotten into a timeout situation when fetching rows from a cursor. My program read the first row, did some stuff for six minutes and then tried to fetch the second row, which failed. The connecti