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 1uKGUF-0001TA-Pv for pgsql-docs@arkaria.postgresql.org; Wed, 28 May 2025 13:06:27 +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 1uKGUD-00HSL1-KD for pgsql-docs@arkaria.postgresql.org; Wed, 28 May 2025 13:06:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uKGUD-00HSKt-Bl for pgsql-docs@lists.postgresql.org; Wed, 28 May 2025 13:06:25 +0000 Received: from mail-lj1-x22a.google.com ([2a00:1450:4864:20::22a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uKGUA-000Ngx-2n for pgsql-docs@lists.postgresql.org; Wed, 28 May 2025 13:06:24 +0000 Received: by mail-lj1-x22a.google.com with SMTP id 38308e7fff4ca-32a72e61a3fso10330791fa.0 for ; Wed, 28 May 2025 06:06:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1748437581; x=1749042381; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=6pAh/rPYXLMQ+ZpukHxOl0jft4yoQhydvkEWVT6IrkY=; b=TXpups2LP2IBISRwVp+OUydm0EoDM7/nX5Gm+az9xjtAkD8vrNtOgGM1kvkaBZYclX xH3dhfbi6UN5hhXYTGAkPUJdCsd8mNBJBxGfo3Vl13H6xfci1pEPDQ9ig9AYhFCiYxVn sB6RsUeygR9JoQ455Opcpk2NZf0Dz2e2uWNUmkBIK0xMNhdbSvEt3hjKnmc6QdtPwaLI oFm8r7RL0+cVlOQ6Ppr1KcpelsttgJhUbYxhAZasB57S+KC8blRRlOULusPXiuhYmwLT 3VocxA+cpq1fz8uLB6A4M1a5dy2hP3DQP2Wm1l4a4pWRqjxmxpkhkuP9cP9UJjF+9+0N 16sg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748437581; x=1749042381; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=6pAh/rPYXLMQ+ZpukHxOl0jft4yoQhydvkEWVT6IrkY=; b=fICbyGNlM8zFVB8KKm3vTu0flP/L0oh87zZnaj1T4sYIAoLjyt0L+AsfFptVQyrHiF lgf7KneglBIcP67Hw2o185bCfhB0QfbeGiODmLM4A8Ka5nfRBDQfKcVXbMm71m3IpNRn 03uNVd5JmVDrpa2tOyV9WZCaRYkNlxsUnxYc2BRX9oe2Jfv1yPrLWTJrTdNk4lrnw1CC CSUHbT806Bz/fs8jgg+S7yV6f5mWdFepYLaD+5qb0O31IHXosIYHOFTLzpyY8JAnSw2V xughMOagNKn0zH5B6okUohSc3e5PS34DSYEVTMcdt8VrINibEVdvBFQorKgpkl4cgfRy y8gg== X-Forwarded-Encrypted: i=1; AJvYcCWlr5pCZdPYPgAppMclefSkM+WJInbjXgfVu1inRAjIVBee/f61n9Fndw63HG/RCm3L8BqilL30Sh5B@lists.postgresql.org X-Gm-Message-State: AOJu0YxLfsJgVWdFNB6PVF4aprqFJn5Eml0eonLhdiKqfwwR851pXwRx gZZuOtEgRiLnt2xjtDtNG7sSV2u1mvfvD+bGAeE8m2f4tISoD9zYNUs+Jq8qwXF4CL5WPH8GRG/ FZZ5T X-Gm-Gg: ASbGncvh0kBLLd8kBEYjQLgGpXE2Ta29LsvQObv/IQAf4/bOVoVRHu8SDJwcpBfpFj5 Q+lwRO6a4bkMEvjbi5ex9cMhZYNkgvZtHq1XPAa1+DxzwIWt752m7HbcgXeL5wa45HpU5xX3GQG 7OTGikDq8rhXwiyWSoyLNNAEIP+wuIRqjHT6ExDh/H970RN5rLmhk7mjVXksMsfsv1i0htQdyNI 4ot8O30GnYJ6rT80tPxPtS67hj5m44A1+IEFnCEMjdTHfJ5lR25HTM/9wxgXlMjn5lnciEeSfUp nnYwALQQzBkKa6fmk8P3gjMlveSdJg2s4Rjf/U5HuqqimJvtYjszohKdA52XrLAyYiBpou9jaV5 +70AN4g== X-Google-Smtp-Source: AGHT+IEwT0WqL6vn8KjgoMse0kOaKkQp8Kbh60YoNbPp+6bPiLl8DLSMIFCcU4/g5oWgCiMrMSRLCA== X-Received: by 2002:a05:6000:1885:b0:3a3:7675:902 with SMTP id ffacd0b85a97d-3a4e5ebb9bcmr4241228f8f.21.1748437562081; Wed, 28 May 2025 06:06:02 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:8117:27e8:bf68:a1b0:6f50]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3a4eab0b596sm1424997f8f.0.2025.05.28.06.06.01 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 28 May 2025 06:06:01 -0700 (PDT) Message-ID: Subject: Re: Documentation should state what happens, when a commit fails From: Laurenz Albe To: mark@makr.zone, pgsql-docs@lists.postgresql.org Date: Wed, 28 May 2025 15:06:01 +0200 In-Reply-To: <174841970441.781.9104306922623804710@wrigleys.postgresql.org> References: <174841970441.781.9104306922623804710@wrigleys.postgresql.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2025-05-28 at 08:08 +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: >=20 > Page: https://www.postgresql.org/docs/17/sql-commit.html > Description: >=20 > Deferrable constraints, deadlocks and possibly other deferred or lazily > evaluated rules are checked upon commit. > What happens if they are not met and the commit statement fails? Does the > transaction then implicitly rollback? Or do I need an explicit rollback? I think it would be good to mention that a failed COMMIT automatically performs a ROLLBACK. Do you want to suggest a patch? Yours, Laurenz Albe