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