Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eIng9-0008Ia-Va for pgsql-hackers@arkaria.postgresql.org; Sun, 26 Nov 2017 03:32:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eIng8-0000nI-24 for pgsql-hackers@arkaria.postgresql.org; Sun, 26 Nov 2017 03:32:24 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eIng7-0000n8-SC for pgsql-hackers@lists.postgresql.org; Sun, 26 Nov 2017 03:32:23 +0000 Received: from smtprelay0100.b.hostedemail.com ([64.98.42.100] helo=smtprelay.b.hostedemail.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eInfz-0001Jo-E8 for pgsql-hackers@postgresql.org; Sun, 26 Nov 2017 03:32:23 +0000 Received: from filter.hostedemail.com (10.5.19.248.rfc1918.com [10.5.19.248]) by smtprelay06.b.hostedemail.com (Postfix) with ESMTP id C8B868D264; Sun, 26 Nov 2017 03:32:11 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 50,0,0,,d41d8cd98f00b204,alvherre@alvh.no-ip.org,:::::::,RULES_HIT:41:355:379:599:967:973:988:989:1260:1277:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1534:1540:1593:1594:1595:1596:1711:1730:1747:1777:1792:2393:2525:2560:2563:2682:2685:2692:2693:2828:2859:2910:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3352:3865:3866:3867:3870:3871:3872:3873:3874:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4250:4605:5007:6120:6261:7901:7903:9025:9121:10004:10400:10848:11232:11658:11914:13069:13311:13357:13439:13894:13895:14764:21080:21433:21627:30051:30054:30070,0,RBL:none,CacheIP:none,Bayesian:0.5,0.5,0.5,Netcheck:none,DomainCache:0,MSF:not bulk,SPF:,MSBL:0,DNSBL:none,Custom_rules:0:0:0,LFtime:2,LUA_SUMMARY:none X-HE-Tag: men84_1316facc83d1e X-Filterd-Recvd-Size: 1872 Received: from alvin.alvh.no-ip.org (unknown [191.125.99.74]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf01.b.hostedemail.com (Postfix) with ESMTPA; Sun, 26 Nov 2017 03:32:11 +0000 (UTC) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 87F2966C; Sun, 26 Nov 2017 00:32:08 -0300 (-03) Date: Sun, 26 Nov 2017 00:32:08 -0300 From: Alvaro Herrera To: Mark Dilger Cc: Tomas Vondra , Adrien Nayrat , Pg Hackers Subject: Re: [HACKERS] PATCH: multivariate histograms and MCV lists Message-ID: <20171126033208.5mlutcgtc52y72v6@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <0938F717-F4A0-4568-83B4-80A19887EA25@gmail.com> User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Mark Dilger wrote: > I understand project policy to allow elog for error conditions that will be reported > in "can't happen" type situations, similar to how an Assert would be used. For > conditions that can happen through (mis)use by the user, ereport is appropriate. > Not knowing whether you thought these elogs were reporting conditions that a > user could cause, I did not know if you should change them to ereports, or if you > should just add a brief comment along the lines of /* should not be possible */. Two things dictate that policy: 1. messages are translated by default for ereport but not for elog. Both things can be overridden, but we tend not to do it unless there's no choice. 2. you can assign SQLSTATE only with ereport. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services