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

From Gregory Stark
Subject Re: pgsql: Update: < * Allow adding enumerated values to an existing
Date
Msg-id 87iqy5ojh5.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: pgsql: Update: < * Allow adding enumerated values to an existing  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-committers
"Andrew Dunstan" <andrew@dunslane.net> writes:

> 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.

The TODO doesn't say anything about there not being restrictions. Only being
able to add to the end seems like a likely such restriction.

And removing entries is "only" an engineering problem where you have to go out
and check that there are no records referencing that entry.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's RemoteDBA services!

pgsql-committers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pgsql: Update: < * Allow adding enumerated values to an existing
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Add URL for: * Allow adding/renaming/removing enumerated values