Re: BUG #2963: PQprepare and transactions.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "DUVAL Jean-Pierre" <jp(dot)duval(at)up-comp(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2963: PQprepare and transactions.
Date: 2007-02-06 05:09:56
Message-ID: 29642.1170738596@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"DUVAL Jean-Pierre" <jp(dot)duval(at)up-comp(dot)com> writes:
> It seems that PQprepare() is using something like DECLARE CURSOR WITHOUT
> HOLD, that is impacted by transactions:
> X) Either destroyed at the end of the transaction.
> Y) Or not possible to do when a transaction is open.

This conclusion is incorrect. I can't tell what's going wrong in your
program, because you did not show it to us, but that's not it.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message William ZHANG 2007-02-06 06:28:15 BUG #2970: "FETCH ABSOLUTE -1" from a holdable cursor failed
Previous Message Tom Lane 2007-02-06 05:05:42 Re: BUG #2962: 8.2.1 lo_creat Documentation incorrect?