Mistake in Syntax definition of ALTER TABLE

Started by PG Bug reporting formover 3 years ago2 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/sql-altertable.html
Description:

I think there's a mistake under "and table_constraint is:" where the
different constraints are listed.
Here: https://www.postgresql.org/docs/current/sql-altertable.html

The definition here allows for CHECK constraints to be deferrable when they
are not.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PG Bug reporting form (#1)
Re: Mistake in Syntax definition of ALTER TABLE

PG Doc comments form <noreply@postgresql.org> writes:

I think there's a mistake under "and table_constraint is:" where the
different constraints are listed.
Here: https://www.postgresql.org/docs/current/sql-altertable.html

The definition here allows for CHECK constraints to be deferrable when they
are not.

It's not a mistake, we are simply not trying to make the syntax diagram
reflect that particular implementation restriction. I doubt that making
it do so would be an improvement: we'd have to have two kinds of
column_constraint in the diagram.

regards, tom lane