Request a Demo
Home   >   mailing lists

Re: The CREATE TABLE documentation groups NOT NULL under table_constraint. - Mailing list pgsql-docs

From David G. Johnston
Subject Re: The CREATE TABLE documentation groups NOT NULL under table_constraint.
Date
Msg-id CAKFQuwbiSN8brEGpMaKWVcfyMBz5ikZwu8AprCZQCS1wd9dNVQ@mail.gmail.com
Whole thread Raw
In response to The CREATE TABLE documentation groups NOT NULL under table_constraint.  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
Tree view
On Friday, April 3, 2026, PG Doc comments form <noreply@postgresql.org> 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.
 

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: The CREATE TABLE documentation groups NOT NULL under table_constraint.
Next
From: Maciek Sakrejda
Date:
Subject: Re: doc: Clarify ANALYZE VERBOSE output