Re: pgsql: Update: < * Allow adding enumerated values to an existing

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Bruce Momjian <momjian(at)postgresql(dot)org>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Update: < * Allow adding enumerated values to an existing
Date: 2008-04-25 17:48:28
Message-ID: 4812196C.5050104@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Bruce Momjian wrote:
> Log Message:
> -----------
> Update:
>
> < * Allow adding enumerated values to an existing enumerated data
>
>> * Allow adding/removing enumerated values to an existing enumerated data
>>
>
>

Where did this come from? Adding values anywhere except on the end of
the enumeration list will be fraught with danger, as will removing them.
In essence, either operation would entail rewriting every table that
used the type. Anything else carries a major risk of corruption. That
seems like a pretty bad idea.

cheers

andrew

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2008-04-25 18:27:18 Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated values to an existing
Previous Message User Pgunittest 2008-04-25 17:21:35 pgunittest - pgUnitTest:

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2008-04-25 18:27:18 Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated values to an existing
Previous Message Robert Treat 2008-04-25 16:51:52 Re: MERGE Specification