Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKH9l-009EWE-AG for pgsql-general@arkaria.postgresql.org; Thu, 20 Jun 2024 12:44:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sKH9h-006grx-Nk for pgsql-general@arkaria.postgresql.org; Thu, 20 Jun 2024 12:44:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKH9h-006gro-Ad; Thu, 20 Jun 2024 12:44:46 +0000 Received: from mout.gmx.net ([212.227.15.18]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKH9f-002eEh-Us; Thu, 20 Jun 2024 12:44:45 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1718887481; x=1719492281; i=karsten.hilbert@gmx.net; bh=GgT+v7+wZeRNnUCqlaNrdtklsj/taRLUvXQwjblRdjQ=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=oMowMio60i5DKoOwHsLv3df1+Sh4FsGtI+KxbRKcYR5GcTftN0qb7KFuERgc4ar+ P1Uw1BRkhXS0hgS4SIZK4M9xVKovKG9G4ZYJOj6ONJTCv1JAJc7+TXuceJiiKRGbe exld4uYt9EXJ1OqfqvYTtUvdJSG1ly0FGZSKAwslGegEMNJ6+P+DQdEB2/d1qzpR4 akPEfSqDoRI48MPPTkKBjU0cVQNcZjIIBvw3KnCBFvLMnkfLkrMA0LuNFqCurkC3r RwsBRMpDJ1Vahler/z/M171yuQUDESZsPXm6GqEz6bWveyAyTuXQ+htEsgP0zhV50 muBLSsqBDWeoK651hw== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.144.215.28]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MWASe-1rsI1z1gK2-00HhAj; Thu, 20 Jun 2024 14:44:41 +0200 Received: from ncq by hermes with local (Exim 4.96) (envelope-from ) id 1sKH9c-0000Kc-1d; Thu, 20 Jun 2024 14:44:40 +0200 Date: Thu, 20 Jun 2024 14:44:40 +0200 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org, pgsql-general@postgresql.org Subject: Re: Transaction issue Message-ID: Mail-Followup-To: pgsql-general@lists.postgresql.org, pgsql-general@postgresql.org References: <65F95FD4-CBEA-4E66-AE63-EBC9F617C988@gmail.com> <7678da90-521-3b52-4bb5-11bc9bdf6d1@appl-ecosys.com> <039e657e-5dbc-4243-8c82-865ccb2c2fe5@aklaver.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:HtSy7WjYe5PLXggrL34NwYznCxaFu8/FkOg7EtvEQwcVaLAdL8T Zc37rWZOPgBwZuj/myVxQDwb2GXJbcQEVRkeJJeappGDEOtOCAZGJJbSSnvN/hLCeDEvzYC BPUNtycSzWIhJ4b5UJioXz9Fm0lqeMvnQ6g0SIx+UbkWq1USn0l5bYimgTDmyfkJHxYzhx6 1uSVbj+xuvkHfiyxKhWag== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:Qb+Rbt22rgc=;dfGHB3eSBSZ6hAP5xZcQ6aSmGuW Kn8IGYuaHNMLdxUsUu/7Nr1O5YDfqN28fdPIllE2LFmlcZjY6q7me6KpX59fjw+gVsHyX7qb5 3UW8CzHmH7sGwkJYSINRF6Iw1abBRlvKC+Sk8Ox6POA1vNcVhWA3e93C/+rq5mez2GS8mR2pB rWDV2uDW3zGAFwmrdfKVwKw6lpnOaTvaN34Iye1PU/cMrA6Ey1B4/QUCr8Ft8fJD9hPsxd1el wf5dRTN+B1E+TXRebqy7hSjFhA2TKfOJARAkluSLn9+UdxPSv++l76ulWJ22xVUgBIBc+uIbc bbkMXt7akVlcUV6HzEA1S3/+S9QJLbuk30kkUCwPyjz/pQXWqMQnvDeNxfc+zWoVEsd2+nf74 VhbJ32PJV/3XQfmvGr4SbYheJkDfLGLjGjaO7PtNgYUSG0wnfNvH39sX+T7mRVbTW2iSCUw9L pfevqkUhYnrSoaMQUzEO2JeK0aQe6ll4RWRGB3lfUum2W0joL87xQK3DErc9Q5K8ObWwwzHXs Z5l4vJRVj17hJnF/VMwBzsK7v8EHLmxsaMjM0vBGO0JWeBBQ1H2AnkzJUHULuwamvNL970Nla aTiNiOUkp8cDoD+qcDFsESA1GKr5Dth5LrDEKoAUz5k/USqwgxEZC4V+8JjyxRrVaJ3iFjh2e neZZ5bwTF32mZ5uSLdSH2y5NFSDa/KPSdvSYNl3SAUiHWlekIH2/zWEx0mNZmSiLj2XjbkTc0 HWGIe3/YLKZtrSu84uow4soX+NJBjnS6F0BmBNz4uqgm3Zkm/eWjuQHOkyx6zYZ1t99++/rRc QNndr/RNRQNuAig24W1uOYnRSvREKe8JRDruzhPOpSXes= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Wed, Jun 19, 2024 at 02:32:07PM -0700 schrieb Rich Shepard: > Yes, I see how this works if the transaction is committed. But before I > commit the transaction I run a select statement to ensure the rows added= are > correct. Can I rollback a commited transaction? I've assumed not, so I w= on't > commit the transaction without testing. And I'm not getting a detailed e= rror > message. Shot in the dark: are you be any chance using tab-completion when running the SELECT before the COMMIT ? I've seen it happen a few times that tab completion ran queries behind the scenes which failed and thereby set the open transaction to abort state ... And, no, I can't reproduce :/ Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B