BUG #14873: table_constraint description missing in ALTER TABLE synopsis

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

Responses

Browse pgsql-bugs by date

  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