Postgres Pro
Downloads
Home   >   mailing lists

Thread: SAVEPOINT issue

SAVEPOINT issue

From
archana srinivas
Date:
Issue: https://www.postgresql.org/message-id/flat/54819FAC.7030103%40vmware.com#a9272ae5995208009dd14cde5585ff2b

Dear Sir,

I am facing the issue (as in URL).

Setting the Protocol value to 7.4-1 makes the application forget its own transaction while doing a select on the previous insert in the same session.

And when Protocol value is set to 7.4-0, then the error in the application is 25P02 

Please suggest how to go about it.

regards
Archana

Re: SAVEPOINT issue

From
Bruce Momjian
Date:
On Tue, Apr  5, 2022 at 07:51:24PM +0530, archana srinivas wrote:
> Issue: https://www.postgresql.org/message-id/flat/54819FAC.7030103%40vmware.com
> #a9272ae5995208009dd14cde5585ff2b
> 
> Dear Sir,
> 
> I am facing the issue (as in URL).
> 
> Setting the Protocol value to 7.4-1 makes the application forget its own
> transaction while doing a select on the previous insert in the same session.
> 
> And when Protocol value is set to 7.4-0, then the error in the application
> is 25P02 
> 
> Please suggest how to go about it.

Please see:

    https://odbc.postgresql.org/faq.html#1.6

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson