Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dEDuA-0001aW-3W for pgadmin-hackers@arkaria.postgresql.org; Fri, 26 May 2017 11:59:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dEDu9-0007zX-G2 for pgadmin-hackers@arkaria.postgresql.org; Fri, 26 May 2017 11:59:41 +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 1dEDtv-0007Y6-3c for pgadmin-hackers@postgresql.org; Fri, 26 May 2017 11:59:27 +0000 Received: from mail-wr0-x22e.google.com ([2a00:1450:400c:c0c::22e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dEDtr-0004dX-P9 for pgadmin-hackers@postgresql.org; Fri, 26 May 2017 11:59:26 +0000 Received: by mail-wr0-x22e.google.com with SMTP id z52so702414wrc.2 for ; Fri, 26 May 2017 04:59:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=yCq3GDHR6GosL/qLCPzMpqqIyXmLjq0bqPxL+XvCZx4=; b=Eqm/aoMDwQjr81P5bJSe8fS/xcZ92jyCk805FKNLji7W7juxIcME86IA+w26vZx4mm v6+cALRazTvKBUhh7xAoc0PFfJTCWAdLJVAIzUWKphGFeQnWSdvf+BHasS7qHZhVFBIc M2ul8FXlsskHpyv7zSgtoRjnytM19W0eK2wFfxdnhY5CrEcW/lqfOTpuloRQruO+FwG4 ccj+x+Vx3OLCJxz773T5kRDQNYmjVmmjng+TZIOKsFG73+OPAnIimQte66eeZuM/dQkw blnXdzORImVqswzg8VXG/0GlvUzZFtXUEwfSstTjhdazT+OfEzzNe78zf5MVXr4uMAr5 4FgQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=yCq3GDHR6GosL/qLCPzMpqqIyXmLjq0bqPxL+XvCZx4=; b=U0Rs3YL0zEOxIXeJMtb8Jb9rhBDamEEtP68morR6nRbD2dyE4vKvYCK+dDUHZuTHxa 1gEBGx6PtuUV8KcPAU0nLno1DSj1UF3xDGr2LW4GXPinzgo/LHGf2BxWC7wjgtlCuDop f3xChJ5YlCzHf5V1iWivfzM/3cUEmqFsyxI9kU5f/rYEd9s38rtNh+rbmN9l8xLrEnEM 83/94HbptEtUpkXXZn1PlvnaWEIcQmoD2sdUBF9dkTl3HTPhUUXIR4Zxt2+1YNrlwgId /W8yVSTkX0AXtHGc90PiiqcIXPBuCgAtIALtAt3dw0CfcnzMivVVsm7zcumOBqHnkHwh F8+g== X-Gm-Message-State: AODbwcBMG1pfkUMYyyA5KyAirbe/HLbaXUSBCsudDVt2Oi/UFFbhaBCa YjtStpmRpx7Bca91VpcxIYmlZvhjWQSP+9o= X-Received: by 10.223.136.252 with SMTP id g57mr1346071wrg.191.1495799961980; Fri, 26 May 2017 04:59:21 -0700 (PDT) MIME-Version: 1.0 Received: by 10.223.136.70 with HTTP; Fri, 26 May 2017 04:59:01 -0700 (PDT) From: Murtuza Zabuawala Date: Fri, 26 May 2017 17:29:01 +0530 Message-ID: Subject: [pgAdmin4] [PATCH] Allow user to create ENUM type without any label To: pgadmin-hackers Content-Type: multipart/mixed; boundary="001a1149186464a44505506c11e4" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --001a1149186464a44505506c11e4 Content-Type: multipart/alternative; boundary="001a1149186464a44205506c11e2" --001a1149186464a44205506c11e2 Content-Type: text/plain; charset="UTF-8" Hi, PFA patch to address below, 1) Allow user to create ENUM type without any labels. 2) Allow user to add new label to existing enum type which do not have any existing labels. RM#2426 -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --001a1149186464a44205506c11e2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

PFA patch to address below,
1) = Allow user to create=C2=A0ENUM type without any labels.
2) Allow = user to add new label to existing enum type which do not have any existing = labels.
RM#2426

--
Re= gards,
Murtuza Zabuawala
EnterpriseDB:=C2=A0http://www.enterprisedb.com
The Enterprise= PostgreSQL Company
--001a1149186464a44205506c11e2-- --001a1149186464a44505506c11e4 Content-Type: text/plain; charset="US-ASCII"; name="RM_2426.diff" Content-Disposition: attachment; filename="RM_2426.diff" Content-Transfer-Encoding: base64 X-Attachment-Id: f_j35sl1x30 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3R5cGVzL19faW5pdF9fLnB5 IGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvdHlwZXMvX19pbml0X18ucHkKaW5kZXggMDMx ZTFiNy4uOWM4OGM2MyAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nl ci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdHlw ZXMvX19pbml0X18ucHkKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdHlwZXMvX19p bml0X18ucHkKQEAgLTkwNSwxNiArOTA1LDYgQEAgY2xhc3MgVHlwZVZpZXco UEdDaGlsZE5vZGVWaWV3LCBEYXRhVHlwZVJlYWRlcik6CiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgJ0NvbXBvc2l0ZSB0eXBlcyByZXF1aXJlIGF0 IGxlYXN0IHR3byBtZW1iZXJzLicKICAgICAgICAgICAgICAgICAgICAgICAg ICkKICAgICAgICAgICAgICAgICAgICAgKQotICAgICAgICAgICAgIyBJZiB0 eXBlIGlzIGVudW0gdGhlbiBjaGVjayBpZiBpdCBoYXMgbWluaW11bSBvbmUg bGFiZWwKLSAgICAgICAgICAgIGlmIGRhdGEgYW5kIGRhdGFbYXJnXSA9PSAn ZSc6Ci0gICAgICAgICAgICAgICAgaWYgbGVuKGRhdGFbJ2VudW0nXSkgPCAx OgotICAgICAgICAgICAgICAgICAgICByZXR1cm4gbWFrZV9qc29uX3Jlc3Bv bnNlKAotICAgICAgICAgICAgICAgICAgICAgICAgc3RhdHVzPTQxMCwKLSAg ICAgICAgICAgICAgICAgICAgICAgIHN1Y2Nlc3M9MCwKLSAgICAgICAgICAg ICAgICAgICAgICAgIGVycm9ybXNnPWdldHRleHQoCi0gICAgICAgICAgICAg ICAgICAgICAgICAgICAgJ0VudW1lcmF0aW9uIHR5cGVzIHJlcXVpcmUgYXQg bGVhc3Qgb25lIGxhYmVsLicKLSAgICAgICAgICAgICAgICAgICAgICAgICkK LSAgICAgICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgIyBJZiB0eXBl IGlzIHJhbmdlIHRoZW4gY2hlY2sgaWYgc3VidHlwZSBpcyBkZWZpbmVkIG9y IG5vdAogICAgICAgICAgICAgaWYgZGF0YSBhbmQgZGF0YVthcmddID09ICdy JzoKICAgICAgICAgICAgICAgICBpZiBkYXRhWyd0eXBuYW1lJ10gaXMgTm9u ZToKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dy b3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3R5cGVzL3RlbXBsYXRl cy90eXBlL2pzL3R5cGUuanMgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZl cl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90eXBlcy90ZW1w bGF0ZXMvdHlwZS9qcy90eXBlLmpzCmluZGV4IDlhMTk1ZTYuLjRjMTAxZmQg MTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3R5cGVzL3RlbXBsYXRlcy90 eXBlL2pzL3R5cGUuanMKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdHlwZXMvdGVt cGxhdGVzL3R5cGUvanMvdHlwZS5qcwpAQCAtMjQxLDE4ICsyNDEsNiBAQCBm dW5jdGlvbigkLCBfLCBTLCBwZ0FkbWluLCBwZ0Jyb3dzZXIsIGFsZXJ0aWZ5 LCBCYWNrZ3JpZCkgewogICAgICAgfQogICAgIH1dLAogICAgIHZhbGlkYXRl OiBmdW5jdGlvbigpIHsKLSAgICAgIHZhciBlcnIgPSB7fSwKLSAgICAgICAg ICBlcnJtc2cgPSBudWxsOwotCi0gICAgICBpZiAoXy5pc1VuZGVmaW5lZCh0 aGlzLmdldCgnbGFiZWwnKSB8fAotICAgICAgICBfLmlzTnVsbCh0aGlzLmdl dCgnbGFiZWwnKSkgfHwKLSAgICAgICAgU3RyaW5nKHRoaXMuZ2V0KCdsYWJl bCcpKS5yZXBsYWNlKC9eXHMrfFxzKyQvZywgJycpID09ICcnKSkgewotICAg ICAgICAgIGVycm1zZyA9ICd7eyBfKCdQbGVhc2Ugc3BlY2lmeSB0aGUgdmFs dWUgZm9yIGxhYmVsLicpIH19JzsKLSAgICAgICAgICB0aGlzLmVycm9yTW9k ZWwuc2V0KCdsYWJlbCcsIGVycm1zZykKLSAgICAgICAgICByZXR1cm4gZXJy bXNnOwotICAgICAgfSBlbHNlIHsKLSAgICAgICAgdGhpcy5lcnJvck1vZGVs LnVuc2V0KCdsYWJlbCcpOwotICAgICAgfQogICAgICAgcmV0dXJuIG51bGw7 CiAgICAgfQogICB9KTsKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dz ZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3R5 cGVzL3RlbXBsYXRlcy90eXBlL3NxbC9kZWZhdWx0L3VwZGF0ZS5zcWwgYi93 ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRh YmFzZXMvc2NoZW1hcy90eXBlcy90ZW1wbGF0ZXMvdHlwZS9zcWwvZGVmYXVs dC91cGRhdGUuc3FsCmluZGV4IDdmMzhlOTcuLjNhMGEzMzYgMTAwNjQ0Ci0t LSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJz L2RhdGFiYXNlcy9zY2hlbWFzL3R5cGVzL3RlbXBsYXRlcy90eXBlL3NxbC9k ZWZhdWx0L3VwZGF0ZS5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9z ZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdHlwZXMv dGVtcGxhdGVzL3R5cGUvc3FsL2RlZmF1bHQvdXBkYXRlLnNxbApAQCAtODcs NyArODcsNyBAQCBBTFRFUiBUWVBFIHt7IGNvbm58cXRJZGVudChvX2RhdGEu c2NoZW1hLCBvX2RhdGEubmFtZSkgfX0KIHslIGlmIGNfaWR4ID09IDEgJX0K IHsjIGlmIGZpcnN0IG5ldyBlbGVtZW50IHRoZW4gYWRkIGl0IGFmdGVyIG9s ZCBkYXRhIGVudW0gbGlzdCN9CiBBTFRFUiBUWVBFIHt7IGNvbm58cXRJZGVu dChvX2RhdGEuc2NoZW1hLCBvX2RhdGEubmFtZSkgfX0KLSAgICBBREQgVkFM VUUge3tyLmxhYmVsfHF0TGl0ZXJhbH19IEFGVEVSIHt7b19kYXRhLmVudW1b b19lbnVtX2xlbl0ubGFiZWx8cXRMaXRlcmFsIH19OworICAgIEFERCBWQUxV RSB7e3IubGFiZWx8cXRMaXRlcmFsfX0geyUgaWYgb19lbnVtX2xlbiA+IDAg JX1BRlRFUiB7e29fZGF0YS5lbnVtW29fZW51bV9sZW5dLmxhYmVsfHF0TGl0 ZXJhbCB9fXslIGVuZGlmICV9OwogeyUgZWxzZSAlfQogeyMgaWYgZmlyc3Qg bmV3IGVsZW1lbnQgdGhlbiBhZGQgaXQgYWZ0ZXIgbmV3IGRhdGEgZW51bSBs aXN0I30KIHslIHNldCBwX2lkeCA9IGxvb3AuaW5kZXggLSAyICV9Cg== --001a1149186464a44505506c11e4 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers --001a1149186464a44505506c11e4--