Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nblQF-0006qi-Se for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Apr 2022 15:48:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nblQE-0004nr-PE for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Apr 2022 15:48:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nblQE-0004ni-He for pgsql-bugs@lists.postgresql.org; Tue, 05 Apr 2022 15:48:46 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nblQC-0003Hl-2o for pgsql-bugs@postgresql.org; Tue, 05 Apr 2022 15:48:46 +0000 Received: from bruce by momjian.us with local (Exim 4.94.2) (envelope-from ) id 1nblQ9-005ii4-EC; Tue, 05 Apr 2022 11:48:41 -0400 Date: Tue, 5 Apr 2022 11:48:41 -0400 From: Bruce Momjian To: archana srinivas Cc: pgsql-bugs@postgresql.org Subject: Re: SAVEPOINT issue Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson