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.96) (envelope-from ) id 1wa4Kq-001Vdv-35 for pgsql-docs@arkaria.postgresql.org; Thu, 18 Jun 2026 04:26:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wa4Kp-009K4u-2B for pgsql-docs@arkaria.postgresql.org; Thu, 18 Jun 2026 04:26:35 +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.96) (envelope-from ) id 1wa4Kp-009K4O-1R for pgsql-docs@lists.postgresql.org; Thu, 18 Jun 2026 04:26:35 +0000 Received: from mail-yx1-xb136.google.com ([2607:f8b0:4864:20::b136]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wa4Kn-00000000ugx-3eHe for pgsql-docs@lists.postgresql.org; Thu, 18 Jun 2026 04:26:34 +0000 Received: by mail-yx1-xb136.google.com with SMTP id 956f58d0204a3-6611669cd16so659398d50.0 for ; Wed, 17 Jun 2026 21:26:33 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781756792; cv=none; d=google.com; s=arc-20240605; b=hFo19LTnwbwVYP0TRfEjuuNknhePV8sGfFkWm28y6LIeiPdxTnYsGPqaSs+02oOfRq ZeA7knMnC8ufEgwfl0audqtWzcWZAXG+3ne3W47Dg0usaY+FI+hPdMz+jQfKo5DOfVYq EKdq7JKoPRoxMJZLl9m69zWd1hsH3n98WQn3AJ+vnCd8O7oLg0YbQbFoTZyh86OBzJ/R VDGttY7eH5NITURq9bcKNxGRjVLOGs+jqCnK1kpIrE7f9eEaU3dG4Y00ZbZ2+7sRH5gJ RDoVWb0Nw+P+xoAkMSXyEO4LGGwafcr5GthJgwxGjHKfon/v7oTIGUSDQzs87/5QzCu9 CC8w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=S55N7rKsJIEyfvon1NFytsqVS4x2fLXKoDzUYKt529M=; fh=wwU9JZP1DG2aee3JeHvjkuLZ/iD4Lmqh2hx00QDJXaQ=; b=C2bJodKf6tNBf/OJE3P9TwWoTJlx1GLWXxLc6lmBpcdXyBBGHkswhgHEWvrZZbHlgP nGaZpiwdnjHYl2fVRf4zPId10sUULwDrxVWtDFlVtnjWugT9xuQhSpV3Gcqhrrh+iy71 EtAzJ4Ppt6AB/vUN2NRYXYhCwT0WClKXA4fmeck0Epxn/itXrGqAycwjznjd0HKAw354 /3Haa1jXpZd3RsE9MO+gLoUN32L5lbFKFAZi0mtt7f3+uszP3CLyTOlT/6TfdpYeWLTp kP+kGpTk9Kov03hq35+/6ya56XCShzu1rp2T1mNHO7gpkSSDhMz44om5bUE0SAgyu1ZJ To/g==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1781756792; x=1782361592; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=S55N7rKsJIEyfvon1NFytsqVS4x2fLXKoDzUYKt529M=; b=pBmmOsVQepYUAw6K0nRB89U1HUjpYGIyxFl18QQgD4NqOWI+k/KXTOC04IXHEEt/79 FxK3rROQBu8WaPN7BwtJw0hQIhPrbxnbXkT1Y3NEOitX578bZbYyOBwE3ph+URYTpdWw FC2lMQRG/KwpYxZePoD6yuyKadIrHiTFpUhl1CXAkB2qVMx+gj030P727VHGBYNVSXJC W6BRiED79UBmmzUhjWYZWScPdYXZDF+YFeCmGZEN74l3fwlar0OzRUOQIavHcfOuU/b7 Ju+mxdnqnZyBTSFLC1QlhaVw75vlwGwLrvzZaQ53X/SErmikrDgWPbSBnhzY/TUuEnrD byDw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781756792; x=1782361592; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=S55N7rKsJIEyfvon1NFytsqVS4x2fLXKoDzUYKt529M=; b=Tk86C4tVhhBMENozLYRwE11mbo7rIA/gFTt9okQRmivlimUXsGHEBbspUHAu3qJQLV 1+MONIRtK0fYZpZ53dxV5GuByANtn6J9mwJ8e1/1V+4TJK3xjEQsd5m+FpTHy4X9eW0l VfjWPA8eS555vI57W9WJh7Ih0WAQSyzgWLQnixQDTsBtQ7PY+mmvYt/3fNxG0fWBM4pX veSoew7nNanCfVTlT3B11KIBMLmWYmHIMvqIw6Qeqt03lwthiiMHkZeIV5NkWs1nVa0g Uk3PBw3Wl99AOo7NH2SS6U2jfCq/fi+/B33q0x5HoWDebitvxBsI+P6WOr7T/lC0zLPo Y5fA== X-Gm-Message-State: AOJu0YywU5rizj+2iF6lll78m6b8M1xM4+WnEqJgMUkIqFdAI93mzipq HVFKYHxhROv9zk8nmXkYYvWfuKvys8VggwrP0q2BMUcQROUbNs9mc56cGykTrschuznbezQTqMa pFL5Zu2lOyCor4WlEtIoaDfhcNcOB4bs= X-Gm-Gg: AfdE7ckBrGbTr/PohTYlKH8CCMEGp4xNV7xAkEpJXuffqeYqa6vY04mwuEjsMESAZzu 5W2tOMzWJ5FbNkKzXZGkRbuteclBidXDceEImZGwVFSKSyTzjZhTf1rsYZruRIl74xKR6ETtvmO XWdMwqFOii+x8fRpgXFulRiFRSliaCr/N6xjTk9gOIpex+b0MaryPWUuj9aNAD6aE1/alTtIQzj 9fyto93PUL1o4+M0ION4OAswd9LIXveCAjyfP71VbyZ5eC3W+EsY2JyRTfr4n+zlqif1fHwTOTd 5c9zNfk57v2FGBtlN+dSzVoh6Qv4 X-Received: by 2002:a05:690e:4259:b0:660:6d41:df5d with SMTP id 956f58d0204a3-662cbcedf87mr5679552d50.46.1781756792543; Wed, 17 Jun 2026 21:26:32 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:7010:e888:b0:52e:d0d7:6ba3 with HTTP; Wed, 17 Jun 2026 21:26:31 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Wed, 17 Jun 2026 21:26:31 -0700 X-Gm-Features: AVVi8CdgLri2C2Rm1R81903z7KoDn48BxktT2ttCgUybEjT4H6tUR9VMhpsdaXU Message-ID: Subject: Re: Doc error re: "not null" "not valid" To: "Pete O'Such" Cc: "pgsql-docs@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000b21de406547f9460" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b21de406547f9460 Content-Type: text/plain; charset="UTF-8" On Wednesday, June 17, 2026, Pete O'Such wrote: > https://www.postgresql.org/docs/9.1/sql-altertable.html > > The text for "ADD table_constraint" says that NOT VALID "is currently only > allowed for foreign key constraints." > > You are commenting on version 9.1 documentation but testing version 18. The 18 docs mention not-null constraints. David J. --000000000000b21de406547f9460 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, June 17, 2026, Pete O'Such <posuch@gmail.com> wrote:

The text for "ADD tab= le_constraint" says that NOT VALID "is currently only allowed for= foreign key constraints."


=
You are commenting on version 9.1 documentation but testing vers= ion 18.=C2=A0 The 18 docs mention not-null constraints.
=C2=A0
David J.

--000000000000b21de406547f9460--