Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlejD-003nS7-KV for pgsql-docs@arkaria.postgresql.org; Thu, 28 Sep 2023 00:18:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qlejA-006h0t-2Z for pgsql-docs@arkaria.postgresql.org; Thu, 28 Sep 2023 00:18:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlej9-006h0f-PK for pgsql-docs@lists.postgresql.org; Thu, 28 Sep 2023 00:18:00 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlej6-007zG0-Oe for pgsql-docs@lists.postgresql.org; Thu, 28 Sep 2023 00:17:59 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2023062407; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:Cc:To:From:Date:Sender:Reply-To:Content-Transfer-Encoding:Content-ID: Content-Description; bh=wdfZ84T9zqs6mvAzNKTRzhI8rmBmLhnFrKFP+Pu+O5Y=; b=b+AD4 5gX2I2nNKdQbjNZ6kUe9EGpKKCphFtEVWjQlB5/PryZN1OvOD7J1EBucMYrNSXLqxQ9xSs5bh5+Eu Gx+ItTKgXHMwfpwxG2vI1yMzMj+1f7ieVcHsM7FiKVKHP/ohAiRuYmqNIVr5rSo7yJVvb/m39hkFl wSWKpQ5O6/qrlR2yQ9ZY8m61rCOnS13mjWoFo2akZRf8AZszbce2HCmCO1Ot6Gww1pZQt0SMSa3Ye K36n/toqBM6ydH5y7k2yJbIL0QSsv6yBR91A7A19zufJgINnRWRpe3DHaXzQcApnb+G2f34EMJQla 9JuLMjqhLiLiFw+OFVvyzGVxktAuw==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1qlej4-007EPa-13; Wed, 27 Sep 2023 20:17:54 -0400 Date: Wed, 27 Sep 2023 20:17:54 -0400 From: Bruce Momjian To: Tom Lane Cc: t.kitynski@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: Suggestion for deprecated spellings Message-ID: References: <167473556945.2667294.2003897901995802549@wrigleys.postgresql.org> <888259.1675112866@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="k+j9PFScSM/35vPC" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --k+j9PFScSM/35vPC Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Jan 30, 2023 at 04:17:14PM -0500, Bruce Momjian wrote: > On Mon, Jan 30, 2023 at 04:07:46PM -0500, Tom Lane wrote: > > Bruce Momjian writes: > > > On Thu, Jan 26, 2023 at 12:19:29PM +0000, PG Doc comments form wrote: > > >> From time to time some spelling for given command gets obsolete, yet it is > > >> shown in the syntax on "equal rights" as other valid clauses. > > > > > We don't need to show all _supported_ syntaxes in the "Synopsis" > > > section, so we could just remove them. > > > > IIRC, there is precedent in COPY for moving obsolete alternatives > > to a separate part of the man page. I'd prefer that to just > > removing them, because then there is no documentation to help > > someone understand what an old SQL script is doing. > > Yeah, I remember that with COPY. t.kitynski@gmail.com, please us that > as a guide. Thanks. I developed the attached patch to move the deprecated clauses to the bottom. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you. --k+j9PFScSM/35vPC Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="group.diff" diff --git a/doc/src/sgml/ref/create_role.sgml b/doc/src/sgml/ref/create_role.sgml index 7249fc7432..6a3cd6d808 100644 --- a/doc/src/sgml/ref/create_role.sgml +++ b/doc/src/sgml/ref/create_role.sgml @@ -36,10 +36,8 @@ CREATE ROLE name [ [ WITH ] password' | PASSWORD NULL | VALID UNTIL 'timestamp' | IN ROLE role_name [, ...] - | IN GROUP role_name [, ...] | ROLE role_name [, ...] | ADMIN role_name [, ...] - | USER role_name [, ...] | SYSID uid @@ -294,15 +292,6 @@ in sync when changing the above synopsis! - - IN GROUP role_name - - IN GROUP is an obsolete spelling of - IN ROLE. - - - - ROLE role_name @@ -326,16 +315,6 @@ in sync when changing the above synopsis! - - USER role_name - - - The USER clause is an obsolete spelling of - the ROLE clause. - - - - SYSID uid @@ -484,6 +463,22 @@ CREATE ROLE name [ WITH ADMIN NOINHERIT attribute, while roles are given the INHERIT attribute. + + + The USER clause has the same behavior as + ROLE but has been deprecated: + + USER role_name [, ...] + + + + + The IN GROUP clause has the same behavior as IN + ROLE but has been deprecated: + + IN GROUP role_name [, ...] + + --k+j9PFScSM/35vPC--