Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d9HIj-0000l8-NT for pgsql-hackers@arkaria.postgresql.org; Fri, 12 May 2017 20:36:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d9HIj-0006jJ-8m for pgsql-hackers@arkaria.postgresql.org; Fri, 12 May 2017 20:36:37 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d9HIh-0006gt-Cv for pgsql-hackers@postgresql.org; Fri, 12 May 2017 20:36:35 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d9HIe-0003nP-N2 for pgsql-hackers@postgresql.org; Fri, 12 May 2017 20:36:34 +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 v4CKaUZN028665; Fri, 12 May 2017 16:36:30 -0400 From: Tom Lane To: Tomas Vondra cc: Alvaro Herrera , Simon Riggs , Andrew Dunstan , PostgreSQL-development , Dean Rasheed Subject: Re: WITH clause in CREATE STATISTICS In-reply-to: <17300.1494597927@sss.pgh.pa.us> References: <20170511221330.5akgbsoyx6wm4u34@alvherre.pgsql> <22676.1494557205@sss.pgh.pa.us> <17300.1494597927@sss.pgh.pa.us> Comments: In-reply-to Tom Lane message dated "Fri, 12 May 2017 10:05:27 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <28663.1494621390.1@sss.pgh.pa.us> Date: Fri, 12 May 2017 16:36:30 -0400 Message-ID: <28664.1494621390@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org I wrote: > Tomas Vondra writes: >> On 5/12/17 4:46 AM, Tom Lane wrote: >>> Although I've not done anything about it here, I'm not happy about the >>> handling of dependencies for stats objects. >> Yeah, it's a bit frankensteinian ... > I'm prepared to create a fix for that, but it'd be easier to commit the > current patch first, to avoid merge conflicts. Done. I noted that we weren't making an owner dependency either :-(. Also, we might want to think about letting stats objects be extension members sometime. As things stand, if an extension script does CREATE STATISTICS, the stats object will just be "loose" rather than bound into the extension. We still have docs and nomenclature issues to work on. Anyone want to take point on those? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers