diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2021-03-12 11:08:42 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2021-03-12 11:08:42 -0500 |
| commit | f52c5d6749a61fc4e0908457c58f5069910d53a6 (patch) | |
| tree | 75a90a5555255c414c7042870b7fc83b9afba13f /doc/src | |
| parent | 1b88b8908e751271933c076234fa085cda251421 (diff) | |
| download | postgresql-f52c5d6749a61fc4e0908457c58f5069910d53a6.tar.gz postgresql-f52c5d6749a61fc4e0908457c58f5069910d53a6.zip | |
Forbid marking an identity column as nullable.
GENERATED ALWAYS AS IDENTITY implies NOT NULL, but the code failed
to complain if you overrode that with "GENERATED ALWAYS AS IDENTITY
NULL". One might think the old behavior was a feature, but it was
inconsistent because the outcome varied depending on the order of
the clauses, so it seems to have been just an oversight.
Per bug #16913 from Pavel Boev. Back-patch to v10 where identity
columns were introduced.
Vik Fearing (minor tweaks by me)
Discussion: https://postgr.es/m/16913-3b5198410f67d8c6@postgresql.org
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 3b2b227683a..71703da85ae 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -840,6 +840,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM column</firstterm>. It will have an implicit sequence attached to it and the column in new rows will automatically have values from the sequence assigned to it. + Such a column is implicitly <literal>NOT NULL</literal>. </para> <para> |