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 1ewg89-0006f2-1F for pgsql-docs@arkaria.postgresql.org; Fri, 16 Mar 2018 03:34:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ewg87-0000i0-3o for pgsql-docs@arkaria.postgresql.org; Fri, 16 Mar 2018 03:34:07 +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.89) (envelope-from ) id 1ewg86-0000hX-MP for pgsql-docs@lists.postgresql.org; Fri, 16 Mar 2018 03:34:06 +0000 Received: from mail-lf0-x244.google.com ([2a00:1450:4010:c07::244]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ewg7y-0007f6-PK for pgsql-docs@lists.postgresql.org; Fri, 16 Mar 2018 03:34:05 +0000 Received: by mail-lf0-x244.google.com with SMTP id v9-v6so13281998lfa.11 for ; Thu, 15 Mar 2018 20:33:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=timbira-com-br.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=xR2NkIa4tPAoiZHbaOh+VhhUu5+n2ZgtyNO21StgfXk=; b=JZonp6hbz31f7yd3LoFX2iOv+wieaD745+dkP1ITMMN7jtciWKz28gTh0R0+WBE4TK 5yuRYQHJwZzZ0Nkk9U6STqXhCBQwZh5NH5/4w3kWjG4FVmNV9IdgP54SJtnYWnSdPsTM ju6Y3ll8h5RjyRb5dyyQ5GxhNBHhzDFXLdPMPdJbuu7lm7vjeh+Oh724HjFS2PTJsfQD /q02tjUX+y0okPn3oONRamILuvY5IiWRLGBfw4GXK1SYjFCi7K1JFvRMx7JPltndgSUF g1B0hFEe0oU0n3RUCOWg+oxx/WVWPuRWrvoX0fXFc4boEPaUXXTVEepstw9XDd2Vm9vG 1GsA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=xR2NkIa4tPAoiZHbaOh+VhhUu5+n2ZgtyNO21StgfXk=; b=JrbY5V/N4Z5a1lpGWLVZ1xxAw6bOjtGEYdlksvrJpAXXMbUWE24ncqb1MYP2eGFq25 X6ZLV/IiTDz+vthlH3j+f7tQMxDqGR6WF6ijOm9DXImLPqkGhZI6HvMloRDNPrHZbpI5 oz126OTkYG3gXIJG7yC4QtJoO5D2eYBQ162lt6EccDuV0+oal/d6vSNvsDPauvha37OZ vN/AOkfaklqa1tDuZmAvRz1wgGekBxi+F9QtKDLobSjXPhPT/1lXH9FA6VMeqDqzdrYa EyD/B8GoW5OniFfjR4GX5Boc0LpPlZ8n+p813jilJ3WHh26X16/NljPSoNvh6vr0BBCE XBmw== X-Gm-Message-State: AElRT7H2ftu+oq8LQBu54Wh7HHvSUW+ZBhI7kz+DuOTOpRKqoaYoMmeS UYJxkpYnni0zhkSJxbgAzA9sBABT8flBiGRNNbXbOc7F X-Google-Smtp-Source: AG47ELsQ/sL3hBGfq7QQP0dvfqdHTSIwnjUJU3JKVs1ljhsgwpt+u44aYlkZxFUf8Qagqb6DwKwOT36Gi8z+TN7h9xU= X-Received: by 2002:a19:6d03:: with SMTP id i3-v6mr186961lfc.34.1521171235555; Thu, 15 Mar 2018 20:33:55 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a19:570c:0:0:0:0:0 with HTTP; Thu, 15 Mar 2018 20:33:54 -0700 (PDT) In-Reply-To: <152089733343.1222.6927268289645380498@wrigleys.postgresql.org> References: <152089733343.1222.6927268289645380498@wrigleys.postgresql.org> From: Euler Taveira Date: Fri, 16 Mar 2018 00:33:54 -0300 Message-ID: Subject: Re: Can we only add values to enums? To: brian@traceme.com, pgsql-docs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 2018-03-12 20:28 GMT-03:00 PG Doc comments form : > I need to add a value to an enum, so I found this page, which answered my > question. However, I found it quite confusing that it only documents adding > a value. I would expect it to also document how to remove a value from an > enum? Is this not possible? If not, I consider it a bug. But either way, if > it is not possible, you should explicitly document it on this page. > If it is not document, this means that it is not supported. It is not a bug. It is by design. Read the discussion about this feature at [1]. Removing a enum value requires a table rewrite. I'm not sure it is worth a note. [1] https://www.postgresql.org/message-id/4C1B95E2.6090508@dunslane.net -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento