Re: pgsql: Update: < * Allow adding enumerated values to an existing - Mailing list pgsql-committers

From Andrew Dunstan
Subject Re: pgsql: Update: < * Allow adding enumerated values to an existing
Date
Msg-id 4812196C.5050104@dunslane.net
Whole thread Raw
In response to pgsql: Update: < * Allow adding enumerated values to an existing  (momjian@postgresql.org (Bruce Momjian))
Responses Re: pgsql: Update: < * Allow adding enumerated values to an existing
List pgsql-committers

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

pgsql-committers by date:

Previous
From: pgunittest@pgfoundry.org (User Pgunittest)
Date:
Subject: pgunittest - pgUnitTest:
Next
From: Gregory Stark
Date:
Subject: Re: pgsql: Update: < * Allow adding enumerated values to an existing