Re: [BUGS] BUG #14873: table_constraint description missing in ALTERTABLE synopsis - Mailing list pgsql-bugs

From Amit Langote
Subject Re: [BUGS] BUG #14873: table_constraint description missing in ALTERTABLE synopsis
Date
Msg-id b1b2dcd0-236a-c996-e76a-6ed3876aa582@lab.ntt.co.jp
Whole thread Raw
In response to [BUGS] BUG #14873: table_constraint description missing in ALTER TABLEsynopsis  (postgresql@arkhena.33mail.com)
List 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

pgsql-bugs by date:

Previous
From: Chris Hanks
Date:
Subject: Re: [BUGS] Connections hang indefinitely while taking a LWLockTranchebuffer_content lock.
Next
From: rhodesm4
Date:
Subject: [BUGS] Creating a table by loading a sql file.