Re: transaction problem using cursors

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: transaction problem using cursors
Дата
Msg-id 162867790706110636t5f1324a8gf7f1a0de23ecdb21@mail.gmail.com
обсуждение исходный текст
Ответ на Re: transaction problem using cursors  ("Pit M." <fmi-soft@gmx.de>)
Список 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 по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Functions that return both Output Parameters and recordsets
Следующее
От: "Pit M."
Дата:
Сообщение: Re: transaction problem using cursors