Re: BUG #14873: table_constraint description missing in ALTER TABLE synopsis

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: postgresql(at)arkhena(dot)33mail(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14873: table_constraint description missing in ALTER TABLE synopsis
Date: 2017-10-27 00:49:16
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


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

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, ...


In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message rhodesm4 2017-10-27 04:55:59 Creating a table by loading a sql file.
Previous Message Chris Hanks 2017-10-26 23:42:23 Re: Connections hang indefinitely while taking a LWLockTranche buffer_content lock.