From: | postgresql(at)arkhena(dot)33mail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | postgresql(at)arkhena(dot)33mail(dot)com |
Subject: | BUG #14873: table_constraint description missing in ALTER TABLE synopsis |
Date: | 2017-10-26 09:44:28 |
Message-ID: | 20171026094428.1475.84129@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14873
Logged by: Lætitia AVROT
Email address: postgresql(at)arkhena(dot)33mail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Kyotaro HORIGUCHI | 2017-10-26 10:05:51 | Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)? |
Previous Message | Michael Paquier | 2017-10-26 05:20:06 | Re: BUG #14872: libpq requires a home directory |