Request a Demo
Home   >   mailing lists

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

From PG Doc comments form
Subject The CREATE TABLE documentation groups NOT NULL under table_constraint.
Date
Msg-id 177521204282.3221089.12751196147738658456@wrigleys.postgresql.org
Whole thread Raw
Responses Re: The CREATE TABLE documentation groups NOT NULL under table_constraint.
List pgsql-docs
Tree view 
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.

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Correct docs about GiST leaf page structure
Next
From: "David G. Johnston"
Date:
Subject: Re: The CREATE TABLE documentation groups NOT NULL under table_constraint.