Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1emLqz-0005cb-Gy for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Feb 2018 15:53:45 +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 1emLqx-0003Sy-GN for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Feb 2018 15:53:43 +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 1emLqx-0003Sf-8x for pgsql-hackers@lists.postgresql.org; Thu, 15 Feb 2018 15:53:43 +0000 Received: from smtprelay0254.b.hostedemail.com ([64.98.42.254] 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 1emLqt-0007Qb-BG for pgsql-hackers@postgresql.org; Thu, 15 Feb 2018 15:53:42 +0000 Received: from filter.hostedemail.com (10.5.19.248.rfc1918.com [10.5.19.248]) by smtprelay05.b.hostedemail.com (Postfix) with ESMTP id AB26E32AFC5; Thu, 15 Feb 2018 15:53:36 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 90,0,0,,d41d8cd98f00b204,alvherre@alvh.no-ip.org,:::::,RULES_HIT:41:152:334:355:368:369:379:599:967:973:988:989:1260:1277:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1534:1542:1593:1594:1595:1596:1711:1730:1747:1777:1792:2393:2525:2559:2563:2682:2685:2693:2736:2827:2859:2915:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3354:3865:3866:3867:3868:3870:3871:3872:3873:3874:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4605:5007:6119:6261:7903:7904:9010:9025:9121:10004:10400:10848:11232:11658:11783:11914:12740:12895:13894:13895:21080:21627:21740:30012:30029:30051:30054:30089,0,RBL:190.121.34.242:@alvh.no-ip.org:.lbl8.mailshell.net-62.14.63.100 64.201.201.201,CacheIP:none,Bayesian:0.5,0.5,0.5,Netcheck:none,DomainCache:0,MSF:not bulk,SPF:fn,MSBL:0,DNSBL:no-ip.org-dnsbl7.mailshell.net-127.4.0.190,Custom_rules:0:0:0,LFtime:70,LUA_SUMMARY:none X-HE-Tag: hope50_22bea58fd21d X-Filterd-Recvd-Size: 2914 Received: from alvin.alvh.no-ip.org (unknown [190.121.34.242]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf14.b.hostedemail.com (Postfix) with ESMTPA; Thu, 15 Feb 2018 15:53:34 +0000 (UTC) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id E7477611; Thu, 15 Feb 2018 12:53:27 -0300 (-03) Date: Thu, 15 Feb 2018 12:53:27 -0300 From: Alvaro Herrera To: Nikolay Shaplov Cc: pgsql-hackers@lists.postgresql.org, pgsql-hackers@postgresql.org Subject: Re: [PATCH][PROPOSAL] Add enum releation option type Message-ID: <20180215155327.52suiqdcf3f4z3ir@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <29235994.NprrEGRed4@x200m> User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Nikolay Shaplov wrote: > В письме от 9 февраля 2018 18:45:29 пользователь Alvaro Herrera написал: > > > Maybe we need some in-core user to verify the string case still works. > > A new module in src/test/modules perhaps? > I've looked attentively in src/test/modules... To properly test all reloptions > hooks for modules wee need to create an extension with some dummy index in it. > This way we can properly test everything. Creating dummy index would be fun, > but it a quite big deal to create it, so it will require a separate patch to > deal with. So I suppose string reloptions is better to leave untested for now, > with a notion, that it should be done sooner or later Do we really need a dummy index? I was thinking in something that just calls a few C functions to create and parse a string reloption should be more than enough. > > I don't much like the way you've represented the list of possible values > > for each enum. I think it'd be better to have a struct that represents > > everything about each value (string name and C symbol. Maybe the > > numerical value too if that's needed, but is it? I suppose all code > > should use the C symbol only, so why do we care about the numerical > > value?). > One more reason to keep numeric value, that came to my mind, is that it seems > to be logical to keep enum value in postgres internals represented as C-enum. > And C-enum is actually an int value (can be easily casted both ways). It is > not strictly necessary, but it seems to be a bit logical... Oh, I didn't mean to steer you away from a C enum. I just meant that we don't need to define the numerical values ourselves -- it should be fine to use whatever the C compiler chooses for each C symbol (enum member name). In the code we don't refer to the values by numerical value, only by the C symbol. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services