Re: transaction problem using cursors

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Pit M(dot)" <fmi-soft(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: transaction problem using cursors
Date: 2007-06-11 13:32:15
Message-ID: 162867790706110632g279a8c41o4890ef9286098c3c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
>
> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2007-06-11 13:34:25 Re: Functions that return both Output Parameters and recordsets
Previous Message Alvaro Herrera 2007-06-11 13:30:21 Re: Functions that return both Output Parameters and recordsets