Обсуждение: The CREATE TABLE documentation groups NOT NULL under table_constraint.

Поиск
Список
Период
Сортировка

The CREATE TABLE documentation groups NOT NULL under table_constraint.

От
PG Doc comments form
Дата:
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.




Re: The CREATE TABLE documentation groups NOT NULL under table_constraint.

От
"David G. Johnston"
Дата:
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.