Re: Cursor timeout in postgres - Mailing list pgsql-general

From Tom Lane
Subject Re: Cursor timeout in postgres
Date
Msg-id 17130.1170784118@sss.pgh.pa.us
Whole thread Raw
In response to Cursor timeout in postgres  (Tim Tassonis <timtas@cubic.ch>)
Responses Re: Cursor timeout in postgres  (Tim Tassonis <timtas@cubic.ch>)
List pgsql-general
Tim Tassonis <timtas@cubic.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

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: pg_restore single table privileges/indexes
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade