[BUGS] BUG #14873: table_constraint description missing in ALTER TABLEsynopsis

The following bug has been logged on the website:

Bug reference:      14873
Logged by:          Lætitia AVROT
Email address:      postgresql@arkhena.33mail.com
PostgreSQL version: 10.0
Operating system:   All
Description:

Hi,

I've seen that in the ALTER TABLE synopsis, the table_constraint definition
is missing. It's not really a bug, as it may be found in the CREATE TABLE
synopsis (and will find it there), but it might be a great idea to add it.

Here are the lines missing:
"and table_constraint is:

[ CONSTRAINT constraint_name ]
{ CHECK ( expression ) [ NO INHERIT ] | UNIQUE ( column_name [, ... ] ) index_parameters | PRIMARY KEY ( column_name [,
...] ) index_parameters | EXCLUDE [ USING index_method ] ( exclude_element WITH operator [, ... ] ) 
index_parameters [ WHERE ( predicate ) ] | FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [,
... ] ) ]   [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON
UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE
]"

Regards,

Lætitia


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs