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 1w93U7-0019Um-2Z for pgsql-docs@arkaria.postgresql.org; Sat, 04 Apr 2026 16:04:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w93U5-00HFum-2u for pgsql-docs@arkaria.postgresql.org; Sat, 04 Apr 2026 16:04:30 +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.96) (envelope-from ) id 1w93U5-00HFue-1t for pgsql-docs@lists.postgresql.org; Sat, 04 Apr 2026 16:04:30 +0000 Received: from mail-yx1-xb133.google.com ([2607:f8b0:4864:20::b133]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w93U3-00000000aDw-11CO for pgsql-docs@lists.postgresql.org; Sat, 04 Apr 2026 16:04:29 +0000 Received: by mail-yx1-xb133.google.com with SMTP id 956f58d0204a3-65032e9cf01so2647373d50.3 for ; Sat, 04 Apr 2026 09:04:26 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775318664; cv=none; d=google.com; s=arc-20240605; b=gVtVNGR73MySO8mZGowIcyWfc9YCA82gfLDw4vBvFYs5Y4AnzcYK8CisYBjUjR/oqy JbYVavA+DAMBqiKScqH4FK4YxA0zmUhZy4asgxqQHh6bm3m/RL8FOnbjC82v2mUkVIMR Bv0G6oQFfgdu9nFN34qCoYcJmA03JLPCgGS5zwyZw1/4QivUynDzGFI4gIQis63PiOLe RLz508ur+PfkVPYKskeQ+e0SiS59VfaLA4J5uXVPs9m6Svs9x3idGl5kJdYvXpyJoe91 Dx0upSrLMAXzIo9VD5NOALuFJly92+6Y83Q6+8urjBOSaG3RSUQCIywMmkXW+/4sSJjc uOIg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:references:in-reply-to:mime-version :dkim-signature; bh=aE4isfffvufC7esfRPMOW67xFkUS+8r81Rpz7ZSpiXk=; fh=Wc5lnHAtIBdb69xY5TuDtuVa/MC7rnD3nQFVr5szI4k=; b=G1S52b7tFgUNIn9rfVrJFIE/o2G7MGCHg/ujw6db1IpLZLtjHoOeJ71ppmwqjAmfB5 ZBPCjtVfEbPjuMt077bh0O/wsItdi+EkimADslicrt/4kSEJ7G7n2HaDUc9Es4BnboZq d/RlJxzFj1hzwFYCxhHdgwsINUPWhQz19+ab+v7ZJcDB/2+icGEQl59hIbUIkvk6Rcf3 kddG22bRxpEbD4j2z0HY41GC1NPNyYfjzSju97rg18pC4BCS/9Pu7HoN0D/jtUfIR7Mv wttkXL9iMvZw7okL7p0bZnFvqaPuTfxHRkdjCyoVFDtWSTup8VpSxdo3JcGbmYAcwmXf QYmQ==; 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=1775318664; x=1775923464; darn=lists.postgresql.org; h=to:subject:message-id:date:from:references:in-reply-to:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=aE4isfffvufC7esfRPMOW67xFkUS+8r81Rpz7ZSpiXk=; b=Q/94fy70mB5VSvwivcUxoUePsd/Cx6J1Rc92A5TUB+q+eqoTagiq1UuFJ5ogFWo+9S d00OV/rvb9/wPg8JfGDSYp+AulEHdo0WKSM1u0fZ/uQYT+uc/6jytR6KOP9oZ3gdc9XQ OcZC9gUQOvFosLsXTzyHwsx+ecp3b66rXF4W0rsNkPfhvDe/62HYm6CF6Jcgv+Fr70Wu 1+VKAEwt3yTvf75T+Sv5PQNjFIkuBL9VPYUlYibc39NN/NmZpMi+hjAitRE/zuldQZqK cguN3ldacmIReBAUSS833O2H61Mc8DlaAyJz61YB2uzKrT6pNO8a/5ShW1XFZvf0xARl /jAw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775318664; x=1775923464; h=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=aE4isfffvufC7esfRPMOW67xFkUS+8r81Rpz7ZSpiXk=; b=Zzc4GcfYKViJhqdvgVjBQ3T0o+7FiYsQaoNIsIn7mtbR2GHMpFEk31M5XOmPyxg3ov xZ7N818+MiaDnI8cWVTo9eZRnPbl/dtXAnEOhRiv45iTjw0xLtp+t9O64LPCmaZqrsOH 1xPMbHxzsYezoQY7znexNjzM4vLD8abucOwhIGvQXJEuku2osi00D5/IZ9IIPZQ8hnGG EprBC9eqkrKBMBi9MWV3dO0YWfaDyyKGlGROG9low+r+J18Kst46nx8J2Drz7zTUhDHy X6BxZb5dm9etYC+EctPIQZymYsMRQV7ERblhSm1bREhoCfOtpBaTqGQxicHUZOrFV35L 9FqA== X-Forwarded-Encrypted: i=1; AJvYcCVQwF/EZr4kipmrjsraGDDkuOTy2JdTxmM4UzwXqtK+IcAXJ4oocmPQesUpeE1LNwsHUeVlp3tUTdI5@lists.postgresql.org X-Gm-Message-State: AOJu0Yxmrtul539WWHE9iScy4p/CRzEmqUrqeb/6kzgOU+palUy1OR53 lPF9xmcsUZYc3I0SN7GzW2069EF6RtSB8Uk2NSG/dCP8Lxev2j0+LjUuq16L4Uqh9VK7WFk0OPG MgSpAvaHQ79eiYmq4LFn95zme3sjBTfM= X-Gm-Gg: AeBDiesYO1V5HSAMCkiJAYe2t5nM/vzoETmIUYhPeDvPcpWdKQHcq+0KMDrJWZhZJbz Ymq4h01G3eIxXjbIFnIkIhMzr16WcWIId9cLUk/9Gl40keasnKcHCNZK4Wpx32IzY6E6Im2BDs4 DfnzcsxxWs0V+cH65+w7jwtk1NYGBo2Uy/CT7noAGH7sOmhA5/4XaBndfA2hDYaACunOqFfjITP Cd4ZCR8w0aceq1ClXDks5SoURS9rKnD0eNGhANL0WauCGGOEGLmUlY3EFLECEmGEe4i0msHO6Ed qQjX6KPR X-Received: by 2002:a05:690e:1c1c:b0:650:5316:1756 with SMTP id 956f58d0204a3-6505316228bmr3385380d50.57.1775318663929; Sat, 04 Apr 2026 09:04:23 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:7010:53cf:b0:50b:f104:b8b7 with HTTP; Sat, 4 Apr 2026 09:04:23 -0700 (PDT) In-Reply-To: <177521204282.3221089.12751196147738658456@wrigleys.postgresql.org> References: <177521204282.3221089.12751196147738658456@wrigleys.postgresql.org> From: "David G. Johnston" Date: Sat, 4 Apr 2026 09:04:23 -0700 X-Gm-Features: AQROBzBIuDj1M9DskwL6Sevq6CY6wnlZhepWpKH6E53a3T-CDYibsyyDtpG-vhM Message-ID: Subject: Re: The CREATE TABLE documentation groups NOT NULL under table_constraint. To: "jnishtha305@gmail.com" , "pgsql-docs@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000053a596064ea496ae" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000053a596064ea496ae Content-Type: text/plain; charset="UTF-8" On Friday, April 3, 2026, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/18/ddl.html > Description: > > Unlike UNIQUE or CHECK, NOT NULL cannot be used standalone at the table > level in a standard way > Example: CREATE TABLE t (a int, NOT NULL a); fails. > It only works as an "out-of-line" constraint in very specific inheritance > scenarios. > As of v18 it works. v17 and earlier do not document it. David J. --00000000000053a596064ea496ae Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, April 3, 2026, PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the w= ebsite:

Page: https://www.postgresql.org/docs/18/ddl.html
Description:

Unlike UNIQUE or CHECK, NOT NULL cannot be used standalone at the table
level in a standard way
Example: CREATE TABLE t (a int, NOT NULL a); fails.
It only works as an "out-of-line" constraint in very specific inh= eritance
scenarios.

As of v18 it works. =C2=A0v17 and earlier = do not document it.

David J.
=C2=A0 --00000000000053a596064ea496ae--