Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1j9lH8-0002xx-0m for pgsql-docs@arkaria.postgresql.org; Thu, 05 Mar 2020 07:50:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j9lH6-0007HQ-Qb for pgsql-docs@arkaria.postgresql.org; Thu, 05 Mar 2020 07:50:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j9lH6-0007DZ-Ex for pgsql-docs@lists.postgresql.org; Thu, 05 Mar 2020 07:50:32 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j9lH4-0004p6-7k for pgsql-docs@lists.postgresql.org; Thu, 05 Mar 2020 07:50:31 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id A5BE02224E; Thu, 5 Mar 2020 02:50:29 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Thu, 05 Mar 2020 02:50:29 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=tiv7QpQJd4kPGaqBrF15MGJbPPh udNzmfTamxo4nAvo=; b=gWMntDzAnqBeDMa5Z8dgkmomog9GzHM0g88hO0PP65n T7c1z84ISOalso9/5u7Ri4UHByBVxM8LPReb3Ku3fIu4dv2VtBKxxo+ID6duxZSJ IdoNmnnrOzpydn0I0rfsPZmiHi5yA584CVfxWY7iWkTDbjrzZ5K6hcd4QhrLzkCu +FwFQmVfex97kdnFLEJ0XLryx7dpOWlBrY8jLQcq7DVPo/tuzOuzt5AE6QZaU+kE OWEaxsMBO73XqrolhQsYcEat85yLOZUc/7krOF/3Fxn26tYfu9LZQrKEcewqmTtV dsNCVQwFXTD8cpdHOtEFbx/MSlvov0ebNp8DFAs/z9w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=tiv7Qp QJd4kPGaqBrF15MGJbPPhudNzmfTamxo4nAvo=; b=G2y4XWxBbiRgaxLNz9S35g kqcKT+HZe06NY5k941U2/rpGDZ5K4xS9IVNEMvxq4F3+QRgx0BplPjX0kSYmnkCZ cmwrGB1pXKI7Q8/DtIHaDCZVsShySNwgTRuJnmvBrObW8mCp4tLrP0goW305v4de KY4T8/fzgqaLGzoJdhnhuNqaD9RwIA4vqQT5wmK/lXy7Inzc+/V93jDAAyb1iUEi vNm40DLCgocNQaORRxFstTwQ2pV1uBClfaHO/XlzSWFbJo0X2dEJbUvuCMZugcPv 43z4aa2Rp3xDhvdbDdPRsbQFPzuuIGJAXvf1rIVO2EU4o+nem/388U3tK2yfHM5g == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedugedruddtledguddufecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdefhedmnecujfgurhepff fhvffukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghq uhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuffhomhgrihhnpe hpohhsthhgrhgvshhqlhdrohhrghenucfkphepudduuddruddtvddrudektddrudekheen ucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthh grvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 816533280060; Thu, 5 Mar 2020 02:50:28 -0500 (EST) Date: Thu, 5 Mar 2020 16:50:26 +0900 From: Michael Paquier To: phipsodelic@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: ALTER TABLE syntax incomplete Message-ID: <20200305075026.GZ2593@paquier.xyz> References: <158290721703.30439.14927692570150175919@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="LXx4g46d83wF7unj" Content-Disposition: inline In-Reply-To: <158290721703.30439.14927692570150175919@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --LXx4g46d83wF7unj Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Feb 28, 2020 at 04:26:57PM +0000, PG Doc comments form wrote: > I believe the documentation page > https://www.postgresql.org/docs/11/sql-altertable.html is missing the action > ADD CONSTRAINT, as it is mentioned in the descriptions of other keywords. The documentation includes this description as part of the subquery "table_constraint". -- Michael --LXx4g46d83wF7unj Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl5gr0IACgkQnvQgOdby QH3LlhAAl19WfsJ+tMxApiT6mPwLRszBoy3PqEVV4WfDC7IhSfqQtZeAU/g1m5jM ly8uh1iaJk4bgYA4xQWrearwwSquGc6aQrdh8JtEBEyr/h+Vpsix1kszi3FyTjku nNwmvleLwdvWOhT0804TUnmiBzFjOrd4jBn5faOBzxdbNwMfsZWs0K5EU5X1Z6Bs guiniIDd6kdbqjqosDkELebjZme4VmLRycS75nkOR80BP6qQRr8kWLmrcXpHYPGK 2MN7mpICjudflxJYrBK1kLK5YC1da1twyWBjlOyKH0QliFDJK41r4wTnocFMqtpg uwcch2dx13tqj7eImq05XD9X+RSCi6owDJkrkmA0FnfcZK6xCYSl+QVqRjk4hODH yKuBaoYp7szRxei2s8fsbjW+tdCKEOEoRfjFjJKHhG7OJttIj8tBbDYZ31e2wbMu fNgoNO/iR6TQ6WDXZeOMFU4CjShe8146dwctqwRK14WoKVqeQPDESoH8ZLuzODsZ fv69H35/GabOsmrbYNp8/V5XItGrwzg8r2cyaBLT2QLMKdGPC3j9Y7oj8DCtc5rm a9RzTnHod4SJo/+gYGoDg+HC48YF/1I876NKXF9PMovfb5867CsPrTpZKGVuuhwa FuSkz5/URX3yELENRf338J9kyg6GnmzDEzFDxPZAKeCbLVuyJwA= =LndG -----END PGP SIGNATURE----- --LXx4g46d83wF7unj--