Search Postgresql Archives

Re: transaction problem using cursors

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Pit M." <fmi-soft@xxxxxx>
Subject: Re: transaction problem using cursors
From: "Pavel Stehule" <pavel.stehule@xxxxxxxxx>
Date: Mon, 11 Jun 2007 15:32:15 +0200
Cc: pgsql-general@xxxxxxxxxxxxxx
Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=TMWMFh2/Za0aIbhjT003rOn+lEt9HZ6FKeE1tCuKDn36zjhSX3keX3WPcYbiJX1oNcflekvnAinOBzaHsZ5D8H+i/A1w31kNdqTaD5JOxk2gvrCZzcUWpSU0FddGQKLv/0W6/jQ7BVoa8SzaXirGR8DkP6uqOLrMEMRtOynx+Fk=
In-reply-to: <f4jhts$k8a$1@xxxxxxxxxxxx>
References: <f4jck1$7fh$1@xxxxxxxxxxxx> <162867790706110459x4e3d74dbyf13f4e7b9857cda8@xxxxxxxxxxxxxx> <f4jhts$k8a$1@xxxxxxxxxxxx>



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- transaction problem using cursors
  - From: Pit M.
- Re: transaction problem using cursors
  - From: Pavel Stehule
- Re: transaction problem using cursors
  - From: Pit M.

Prev by Date: Re: Functions that return both Output Parameters and recordsets
Next by Date: Re: Functions that return both Output Parameters and recordsets
Previous by thread: Re: transaction problem using cursors
Next by thread: Re: transaction problem using cursors
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux