Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aj9rm-0002gg-U2 for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Mar 2016 18:20:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1aj9rl-00081X-PO for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Mar 2016 18:20:17 +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 1aj9rk-0007zg-7g for pgsql-hackers@postgresql.org; Thu, 24 Mar 2016 18:20:16 +0000 Received: from plane.gmane.org ([80.91.229.3]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1aj9rc-0003qv-LQ for pgsql-hackers@postgresql.org; Thu, 24 Mar 2016 18:20:15 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1aj9rX-0004N0-SY for pgsql-hackers@postgresql.org; Thu, 24 Mar 2016 19:20:04 +0100 Received: from dalvik.ping.uio.no ([193.157.115.211]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 24 Mar 2016 19:20:03 +0100 Received: from ilmari by dalvik.ping.uio.no with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 24 Mar 2016 19:20:03 +0100 X-Injected-Via-Gmane: http://gmane.org/ Mail-Followup-To: pgsql-hackers@postgresql.org To: pgsql-hackers@postgresql.org From: ilmari@ilmari.org (Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?=) Subject: Re: Alter or rename enum value Date: Thu, 24 Mar 2016 18:18:11 +0000 Lines: 15 Message-ID: References: <56E049CC.8010201@dunslane.net> <25605.1457539654@sss.pgh.pa.us> <56E05635.70908@dunslane.net> <28167.1457543612@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: dalvik.ping.uio.no Mail-Copies-To: nobody User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.2 (gnu/linux) Cancel-Lock: sha1:OA8szDN5W7HR2aFVd923P6fCTbQ= X-Pg-Spam-Score: -2.6 (--) 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 ilmari@ilmari.org (Dagfinn Ilmari Mannsåker) writes: > > I was bored and thought "how hard could it be?", and a few hours' > hacking later, I have something that seems to work. It doesn't do IF > NOT EXISTS yet, and the error messaging could do with some improvement, > and there are no docs. The patch is attached, as well as at > https://github.com/ilmari/postgres/commit/enum-alter-value I've added it to the 2016-09 commitfest as well: https://commitfest.postgresql.org/10/588/ -- "A disappointingly low fraction of the human race is, at any given time, on fire." - Stig Sandbeck Mathisen -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers