Re: Cursor timeout in postgres

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tim Tassonis <timtas(at)cubic(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cursor timeout in postgres
Date: 2007-02-06 17:48:38
Message-ID: 17130.1170784118@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tim Tassonis <timtas(at)cubic(dot)ch> 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 second row, which failed. The
> connection however was still alive and further database access in the
> program worked m'kay.

Failed how, exactly? Did anything show up in the postmaster log?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F. O'Connell 2007-02-06 17:51:33 Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade
Previous Message Alan Hodgson 2007-02-06 17:47:15 Re: pg_restore single table privileges/indexes