Skip site navigation (1) Skip section navigation (2)

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

From: "Brendan Jurd" <direvus(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "Bruce Momjian" <momjian(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated values to an existing
Date: 2008-04-25 18:40:16
Message-ID: 37ed240d0804251140sefb215p42fdfc34588ca91a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, Apr 26, 2008 at 4:27 AM, Alvaro Herrera  wrote:
> Andrew Dunstan wrote:
>  >
>  > Bruce Momjian wrote:
>  >> Log Message:
>  >> -----------
>  >> Update:
>  >>
>  >>   >>
>  >>> * 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.
>
>  We already support rewriting tables ... (albeit only one at a time, I
>  admit.  Doing it for more than one can cause deadlocks).
>
>  Still, if the user wants to pay the cost, why should we prohibit it?
>

I agree with Alvaro's sentiment here, but it  does seem likely that
adding an value to the end of an enum list is much lower-hanging fruit
than add/remove.

Has anyone had a close look at how hard it would be allow just the
"add to the end" capability?

Cheers,
BJ
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: http://getfiregpg.org

iD8DBQFIEiWO5YBsbHkuyV0RAo5pAKDMQ7aAbJJyIe74c+PacXVXg5chXACdEnv3
sFiNsSf193/C9HpW5UVhYWs=
=jOzI
-----END PGP SIGNATURE-----

In response to

Responses

pgsql-hackers by date

Next:From: Gregory StarkDate: 2008-04-25 18:46:46
Subject: Re: Proposed patch - psql wraps at window width
Previous:From: Alvaro HerreraDate: 2008-04-25 18:27:18
Subject: Re: [COMMITTERS] pgsql: Update: < * Allow adding enumeratedvalues to an existing

pgsql-committers by date

Next:From: Gregory StarkDate: 2008-04-25 18:52:22
Subject: Re: pgsql: Update: < * Allow adding enumerated values to an existing
Previous:From: Alvaro HerreraDate: 2008-04-25 18:27:18
Subject: Re: [COMMITTERS] pgsql: Update: < * Allow adding enumeratedvalues to an existing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group