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 1jC2Nz-0002Mm-JS for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2020 14:31:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jC2Nx-0007sZ-T4 for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2020 14:31:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jC2Nx-0007sS-KZ for pgsql-hackers@lists.postgresql.org; Wed, 11 Mar 2020 14:31:01 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jC2Nv-00045x-CU for pgsql-hackers@lists.postgresql.org; Wed, 11 Mar 2020 14:31:01 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id 02BEUre7003927; Wed, 11 Mar 2020 10:30:53 -0400 From: Tom Lane To: Alvaro Herrera cc: Ibrar Ahmed , Ahsan Hadi , PostgreSQL Hackers Subject: Re: more ALTER .. DEPENDS ON EXTENSION fixes In-reply-to: <20200311141412.GA20749@alvherre.pgsql> References: <20200311141412.GA20749@alvherre.pgsql> Comments: In-reply-to Alvaro Herrera message dated "Wed, 11 Mar 2020 11:14:12 -0300" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3925.1583937053.1@sss.pgh.pa.us> Date: Wed, 11 Mar 2020 10:30:53 -0400 Message-ID: <3926.1583937053@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Alvaro Herrera writes: > I'm still not sure whether to apply 0003 (+ your tab-completion patch, > thanks for it) to backbranches or just to master. It seems legitimate > to see it as a feature addition, but OTOH the overall feature is not > complete without it ... 0003 is the command addition to allow removing such a dependency, right? Given the lack of field demand I see no reason to risk adding it to the back branches. BTW, I did not like the syntax too much. "NO DEPENDS ON EXTENSION" doesn't seem like good English. "NOT DEPENDS ON EXTENSION" is hardly any better. The real problem with both is that an ALTER action should be, well, an action. A grammar stickler would say that it should be "ALTER thing DROP DEPENDENCY ON EXTENSION ext", but perhaps we could get away with "ALTER thing DROP DEPENDS ON EXTENSION ext" to avoid adding a new keyword. By that logic the original command should have been "ALTER thing ADD DEPENDS ON EXTENSION ext", but I suppose it's too late for that. regards, tom lane