Обсуждение: [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

Hello.

On 2017/10/26 18:44, postgresql@arkhena.33mail.com wrote:
> 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.

I too had wondered about this once.  Although, you might have noticed in
Description that the CREATE TABLE page is linked in the the first sentence
of the paragraph describing the ADD table_constraint sub-command:

ADD table_constraint [ NOT VALID ]

This form adds a new constraint to a table using the same syntax as CREATE
TABLE, ...

Thanks,
Amit



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