Re: transaction problem using cursors - Mailing list pgsql-general

From Pavel Stehule
Subject Re: transaction problem using cursors
Date
Msg-id 162867790706110636t5f1324a8gf7f1a0de23ecdb21@mail.gmail.com
Whole thread Raw
In response to Re: transaction problem using cursors  ("Pit M." <fmi-soft@gmx.de>)
List pgsql-general
>
> Unfortunately this is not possible, because this should happen on the
> client. The client calls FETCH for every record available in that cursor
>     when the user (application) wants to display the data (scrollable
> list of records)
> So do you think i should wrap each FETCH statement?
> We handle exceptions errors through libpq, and if a FETCH leads to such
> a runtime error, we try to FETCH the first record again.
> The problem is that we can't use this cursor any more -> it seems to be
> corrupt after that error.
>

Change your SQL statement. It is not correct with your real data.

Pavel

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Functions that return both Output Parameters and recordsets
Next
From: "Pit M."
Date:
Subject: Re: transaction problem using cursors