Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject Re: transaction problem using cursors
Date
Msg-id 162867790706110632g279a8c41o4890ef9286098c3c@mail.gmail.com
Whole thread Raw
In response to Re: transaction problem using cursors  ("Pit M." <fmi-soft@gmx.de>)
List pgsql-general
Tree view 
>
>
> Yes i know that i can't, but why the transaction fails?
>

because casting fails. First FETCH was ok, and evaluating of next row
(which need second FETCH) was broken. When any statement in
transaction fail, you have to rollback current transaction.

Pavel

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Functions that return both Output Parameters and recordsets
Next
From: Michael Fuhr
Date:
Subject: Re: Functions that return both Output Parameters and recordsets