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 1jC7d5-0003qk-0h for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2020 20:06:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jC7d3-0000b2-OJ for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2020 20:06:57 +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 1jC7d3-0000av-Aw for pgsql-hackers@lists.postgresql.org; Wed, 11 Mar 2020 20:06:57 +0000 Received: from mail-qk1-x744.google.com ([2607:f8b0:4864:20::744]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jC7d0-0006rD-DP for pgsql-hackers@lists.postgresql.org; Wed, 11 Mar 2020 20:06:56 +0000 Received: by mail-qk1-x744.google.com with SMTP id b5so3388812qkh.8 for ; Wed, 11 Mar 2020 13:06:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=7lzyVA9t1tAlRe7XU+R9Oj1cVRp6JEOvMHZGuMb+epU=; b=a5oUih0POnxHxzDy3+iLLmfNk0vBa8XkA9i0orlHCGK8QGZUgxgrWdLijPCZUxUPSi z3Xqbdowz4x7wp52sELvsMpY6iD1SyVDi2rHEU6GYoBZwRcbQBWf5vzGBc+CgwKPyx2d cmDWG2LPwzw9h9x3OmQP8hj8wix2M9FRioUpfimEnjwQumhQ+bzXmi870PeUv3+Xfz5P oG9WpW/ByMm0qb90pIpmyER7nd7MpiVFz+eKjd1BYOPCO7vlTI3947P4AbWCLk4p6XDC BZgOzuX8j6B0uSzlqOFvJ7jGdQ9Syr7F0wbFy+mkagLQFQJCNBKOmjN0CpL4dHvnRfWr MJpQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=7lzyVA9t1tAlRe7XU+R9Oj1cVRp6JEOvMHZGuMb+epU=; b=Aw5aWTzC7DELc3Mz1rNGhIROYcXpkpDoc8cqD7ywBHmjTtzZn+Sb5pi/JZ7P8rFfq7 Z1TmBs7ER/cJ1ZQYZ/8Ar0Zp4iBSi8iqeeUCKit0MU7lOLLocLgzT4FvUIURUsOLIc7A fB9IoPSH/y8wgxBBbgN+YdogjHrqnDxA+lkQByVoaaK+ba8aO4Hvd9BHX7S7DnlZtLnz a4mAt+7ELlOIjCZY0g8pT4yb58SjAgAAJlFKtLxDM5REaOYiNIQPPw4RCsv3wnodErJS EXs9BXAYZ2SYHzj4wF3yXr8VCxNK9f8Ozj/rQR0eAyLceOMrO+E27bQu509l/AlaOAsd DNNg== X-Gm-Message-State: ANhLgQ0ghOK3+3j2ylCDdaAGCGFMUzG700BYHCldpZzZe454qD2Ih5vO s26zOTnwp118coTTcygJiBbDmA== X-Google-Smtp-Source: ADFU+vuPJMLgONLdPBW64mb9KW425tPe3HngnhQEVjX1g9UNZOgl4DepKAvzAgeiKO4uNbDLiIBgDw== X-Received: by 2002:a37:b944:: with SMTP id j65mr4395142qkf.374.1583957211551; Wed, 11 Mar 2020 13:06:51 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([201.186.80.5]) by smtp.gmail.com with ESMTPSA id x3sm2008350qkn.37.2020.03.11.13.06.50 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 11 Mar 2020 13:06:50 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id EE679300AAD; Wed, 11 Mar 2020 17:06:48 -0300 (-03) Date: Wed, 11 Mar 2020 17:06:48 -0300 From: Alvaro Herrera To: Ibrar Ahmed Cc: Ahsan Hadi , PostgreSQL Hackers Subject: Re: more ALTER .. DEPENDS ON EXTENSION fixes Message-ID: <20200311200648.GA638@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Thanks for the reviews; I pushed 0001 now, again to all branches since 9.6. Because of the previous commit, the fact that multiple statements are emitted is not important anymore: the server will only restore the first one, and silently ignore subsequent ones. And once you're using a system in that state, naturally only one will be emitted by pg_dump in all cases. What remains on this CF item is the new feature to remove an existing dependency. As Tom says, given the little use this feature gets it doesn't sound worth the destabilization risk in back branches, so I'm going to push it only to master -- but not yet. Thanks, -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services