Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ajH8W-0004J6-82 for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Mar 2016 02:06:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ajH8V-0005lq-EO for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Mar 2016 02:06:03 +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 1ajH8R-0005is-Hx for pgsql-hackers@postgresql.org; Fri, 25 Mar 2016 02:05:59 +0000 Received: from mail-by2on0087.outbound.protection.outlook.com ([207.46.100.87] helo=na01-by2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ajH8L-0004kx-KV for pgsql-hackers@postgresql.org; Fri, 25 Mar 2016 02:05:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=j+fOPItN3KiTGH0a/yj/jvtzKnPYE7PhQoDM5VF4gRo=; b=LehzetNpLEr3pL0xkloUVkZmFdjfbGkkmhetkQZGYV4B7SW/tINkjxncxKQnEOHwluy+iFteVbTV7INxFL57V/MDJSljFdNy8mZg4Jy6WgF8VytNazQc7kmrGiCmH0HyRf7LJJLdIJab6Zo+1pCZ9R6dAatgmXn+TBohXK9EVTY= Authentication-Results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=BlueTreble.com; Received: from decina.local (70.113.16.71) by BLUPR11MB0674.namprd11.prod.outlook.com (10.163.216.144) with Microsoft SMTP Server (TLS) id 15.1.434.16; Fri, 25 Mar 2016 02:05:48 +0000 Subject: Re: Alter or rename enum value To: Matthias Kurz , References: <56E049CC.8010201@dunslane.net> <25605.1457539654@sss.pgh.pa.us> <56E05635.70908@dunslane.net> <28167.1457543612@sss.pgh.pa.us> From: Jim Nasby Message-ID: <56F49CF8.8050007@BlueTreble.com> Date: Thu, 24 Mar 2016 21:05:44 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:38.0) Gecko/20100101 Thunderbird/38.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [70.113.16.71] X-ClientProxiedBy: BY2PR1001CA0013.namprd10.prod.outlook.com (25.164.163.151) To BLUPR11MB0674.namprd11.prod.outlook.com (25.163.216.144) X-MS-Office365-Filtering-Correlation-Id: b8a4844e-b836-47c0-a7fe-08d35451fc1a X-Microsoft-Exchange-Diagnostics: 1;BLUPR11MB0674;2:G6s3KTyg0sD+8y1JXDiVQPBmBJWWKU9vpTHc+98daoISEJWBaVTjmaUQ310JX4pbejtMAxlbLMT2A5nP8mNmmw3moyZ9mQS7k/mupE/OXy6CyQRPR6sWdUvWKXxJSGtp4LkYJA5CW0jWAVxU5mlnvG+Wmfkm009jXmJscawmakkYbVtmIzxcyeFve+2a91FR;3:0d9pWokIyzu6Sbp+Ffm0hkgpunDCWEqLg3eGreUs+hBaWzLt0hpPLfxKFFCCUeNugnpyy4Sxpsat3rNREI+YeW8UDZnF9vHyq6lnaRd+7hlKW8onpn+ca8ykpXvfAxSh X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BLUPR11MB0674; X-Microsoft-Exchange-Diagnostics: 1;BLUPR11MB0674;25:dKE8+sUFhC5WOH6baowseJhuVlnAgGSFFfWS25vWTgHW0RjBuYjducT3Julaep4CvMCblOEoB6LPez+g2zduQrYca0QCDImodORO6+3nhU3dVJcwoI82jY3eCn0c6VvPDvfHYOeC74WKzrgPp2x+M530da49K93Ia23E2K+rWXf86Mi4yMXvQBkzie06eL/uoSngk/Bs7MO9csmaVDO6YMa38YkjvAiMeegFiIea0iMZHOwoejCJQkfukCogDgOW8IY8bSDejkylUcFp6wWwvOw1l/puV6MYAjJc/l0jzOb/yNAMq61L4t4okNrEIngABE1OJnh39BhuR2hhrnG6DXZu+k8m+/wwjBQqTjUwiBlwAyYZOgZhJi4OKLtcZ6f4/CCpRRIifVlt2HExN6wqwJ6S8C0u8ril3TKsyh8+A+KGJe8lAJZBe1guLQ71YA34J1KAcS5ums3A2xiPuZH9Lsx7k9+5DAIPjjzRlC5UQfLlgp6THPmgkOyNLMuwewo3JyipyunIQ4bpVooz8MqrzMry3YAP2780EQavvKPt4+KO68mHmDMroS4BhsD1cOyjWptuXFbB3Oy5N7ktfhwOh1dbfJhF1rZ0VBYm47tjzNyf/dkr6d7d/gtefP1alic8vMKzptICyJY/SYU3+DPqUeEyS9d+CgMYBkenXp6BufQ= X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040046)(601004)(2401047)(8121501046)(5005006)(10201501046)(3002001)(6041046)(6043046);SRVR:BLUPR11MB0674;BCL:0;PCL:0;RULEID:;SRVR:BLUPR11MB0674; X-Microsoft-Exchange-Diagnostics: 1;BLUPR11MB0674;4:9AOhDTlS/tFo2stAgbBvqf4K4J+KuLigYPV3hFDNGjtq3z0iITHcejnqsuBRVP/mkbdrBmiZSvjS6tLCXHx6M6ThLDmRuItz5b8UdV83VC9tisgEb8TUiWVS0/77LurMa/es2Bd8SYfuXKdFQ9nsjzDGM07vpgMYAE7tb3fWGVT1DDaFDPbDxJnh//s1mwwaxmR2GJGa4iwMcWAXZE053FYZXA9shYYLVFNy9XZ2LFRkkmA5B06rfH3LrwOyHcU0Yaj5Zlq43jRCrfpDThsaCdvsY0r8cigPFQzwoJCsXX6J68Vbh3YZJUPcVesskcuynpNEDN5BHgAxxJbalPLL4d+8AXn+U/FaoYtgcMb/0F51BnBh3UbvTu4CzoH9mGnealHfq03E13uC+H80oYHuj7h8MBElP67xEmrp082AOco= X-Forefront-PRVS: 0892FA9A88 X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(24454002)(377454003)(5001770100001)(64126003)(54356999)(50986999)(87266999)(76176999)(93886004)(83506001)(4001350100001)(2950100001)(23676002)(65816999)(1096002)(551934003)(6116002)(3846002)(86362001)(33656002)(50466002)(5004730100002)(81166005)(5008740100001)(42186005)(2906002)(77096005)(586003)(47776003)(80316001)(230700001)(92566002)(65956001)(107886002)(36756003)(189998001)(19580395003)(15975445007)(65806001)(66066001)(85282002)(18886065003);DIR:OUT;SFP:1101;SCL:1;SRVR:BLUPR11MB0674;H:decina.local;FPR:;SPF:None;MLV:sfv;LANG:en; X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtCTFVQUjExTUIwNjc0OzIzOkNuY2Z1d2NSeldwQVRwMm12UDUzSTZ5Z2JN?= =?utf-8?B?MG5wVmc5cFE2ZjZKa0g3bGcySnJUMng4cWtNRm9TTXFTNWFXOWNndDAyZGpW?= =?utf-8?B?UHFmMityLzg3MUFDTzNlSG1xdUZiRi9wV2FvZ0J1TFJUTTNkWDBCMk5IRTJF?= =?utf-8?B?OFpQWHhzTW01dDcwQVljUGpqSHhkeEp0blE3TDUza0RwcHdRaDJFNEdFalJV?= =?utf-8?B?a0FhZTdxd2dIS1V2QzhZLzhvTjJzY3FmaWJMQmFhZXE0T21mZnpyVnlDc0xS?= =?utf-8?B?MDc2TUNCL0ZTQWhUOWVVd2JQZDVXN2o4T3loUWhjbXVjb21abW9mSTVVd3U5?= =?utf-8?B?ZUJncEFPSyt2enhJdlVyMkhGOW1HMytoZUpMTVFvamN0bWkxUzVxWUpRek1I?= =?utf-8?B?V3JzYzhRL3BNMjd2VlRKWmcwOFBBTDlxRnNibXlwUk52WXZhSnc0Yjc1eHU5?= =?utf-8?B?aUFEQnBNWGRROHhQbWRLSWxteTd0L01EZUd6TDdhQ3ozbEZpM2lCZ0N3RmNi?= =?utf-8?B?MlhMR0dJbUFkbFdDYjRvN3FDVlFwS082Y1pOeFc2Q1QvckQyN2JvdFNyVkc1?= =?utf-8?B?WWZKQWdUd05UbFpvVENXcGNwckwrL1RTd2JUclN2WnJPVDdtby9KRTRpd2lD?= =?utf-8?B?dWRmUk44NkJPSEZBSTBlcjdaZ3A1NjZycWlOK3M0bWVXd01Qd3JuU0pKYmpj?= =?utf-8?B?aGtCTnNEa0ZjbStvQnMyRk1mTFhDQ293ZFdCeVJYaUpPNXdTWjFaQ1lpeW4w?= =?utf-8?B?WXlDUGpaNkZ5SE53ZXQwQk4yRzZsSURHcHdSclJHTEpCcXEvbzdMTGVFK1R5?= =?utf-8?B?UmNWd0FTdjB1V3FFWmw3MGw1eXg5VlBJQ3kxcFJKQkdlTVBjdUQyakNVeHU4?= =?utf-8?B?d3FrWDRNcThsVUFXbnZ5WmxEYVdyV29yazBXcTVxV0VOOVJaQmUvSkFaYmtz?= =?utf-8?B?VC9DSVBUVHY0bE9UanJGQit2dnJIb1FpR3RzVzMrWjc4Qk15dzFPSmVvdGVO?= =?utf-8?B?V2NaUWhrTEhvVzhlcER2SU5SaUtuQ2lMK2RJa2xRQ0pHRlluSTFVM05URjNl?= =?utf-8?B?Q3pyL28rWVVKRXhMcUtIVDF2VWdHYi9jSnFBeEgvbFZMTHRUd1JFTmFqMHB0?= =?utf-8?B?QUNUaHdMT3JiWEwreXAyeDQ4TjFibW9jMHpSUGM3SjVSYWMxb0doSGxncnhy?= =?utf-8?B?M3c0QW52cnMwT1NJT0hjUHZBbVMvT0hIQnpEWFZLY3V2SjdtdW91dmExY3RV?= =?utf-8?B?MFltNUdVMFZERHIwZ0d3MHFDUUwyZ243UXhaSDMwMzVkWkN2QjVUVlR0Nkw5?= =?utf-8?B?dm9YaWN3a014cXhUWXVFR2RVMTFvOVhxM2xXKzhCTGdRM2RyNHQzVTFuV2V1?= =?utf-8?B?MVVibFUzYmR3SUZyb3kxT3FpMTdpc0t6VW9QYUhxeTgxanMzZ0gxOXpneEpQ?= =?utf-8?B?UXNNQ1ZTc25LMWIxaFRDT2x1NXVaSGZSMXNuNnY4VkdwcWh3TURjcnh4WmRE?= =?utf-8?B?VzZmRzNmakFlTzhzM21nMkl1UWN1cFpmbG5RSzBWOWFTWEVJSGdBTWQ5bDNG?= =?utf-8?Q?CC0w21zSqcRnVN+lwMO51XI6Ver3hBUIJuFSt73DsTWc=3D?= X-Microsoft-Exchange-Diagnostics: 1;BLUPR11MB0674;5:tUZYZHledrieaUo/5mXySVIrj/yDM8EkCJL/J7emCGe8JgDZRNaU/Ae6P13+AWjDu1Swpf8ZhLt84o6os3RZn+2Iq3P2X07ycw/Z+/K3LPbneTWJccG2EdZtmgFMECcONztFLdqDFJcpgi5lInnyeQ==;24:ymYoj8+c3i2PwgxNgSYa2s2Lq3cVwmb0iuu7FzvSVmJaVvfj9PYrtPfICdSKPtONPLBadHMz7VYmOSizdB1W7aQqIk50Pm7Z295z0x5VzOk= SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 25 Mar 2016 02:05:48.2592 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: BLUPR11MB0674 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 On 3/24/16 2:00 PM, Matthias Kurz wrote: > ALTER TYPE bogon DROP VALUE 'cat'; -- not implemented in 9.5 but should > work in future > ROLLBACK; Dropping a value is significantly harder because that value could be in use. I'm certain there's a really good reason adding new values isn't allowed inside of a transaction. It's probably documented in the code. To answer your question about "what goes into a release", there's really no process for that. What goes into a release is what someone was interested enough in to get community approval for the idea, write the patch, and shepard the patch through the review process. So if you want these features added, you need to either: do it yourself, convince someone else to do it for free, or pay someone to do it for you. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers