| From: | "Brendan Jurd" <direvus(at)gmail(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "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 20:10:58 |
| Message-ID: | 37ed240d0804251310qff5cc2dy31e425fd7721547c@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Sat, Apr 26, 2008 at 6:02 AM, Tom Lane wrote:
> "Brendan Jurd" writes:
> > Has anyone had a close look at how hard it would be allow just the
> > "add to the end" capability?
>
> The problem is you can't guarantee anything about the ordering of the
> new value relative to the old ones. The OID it's assigned might be
> after them, or before them if the OID counter has wrapped around,
> or (with much smaller probability) between two existing ones.
>
I see. So to add a value on to the end with guaranteed ordering, you
would have to rebuild the enum from scratch anyway.
Then there's no technical difference at all in implementing "add to
the end" and "add/remove".
Thanks for the answer.
Cheers,
BJ
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: http://getfiregpg.org
iD8DBQFIEjrO5YBsbHkuyV0RAogmAKC3u8wogvrUNSfFUx/PbKyS6U2/DgCgjDSu
z+VNazq7LiRdiU4oUvKL0jc=
=obXq
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Dunstan | 2008-04-25 20:19:50 | Re: Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated values to an existing |
| Previous Message | Tom Lane | 2008-04-25 20:02:04 | Re: Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated values to an existing |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-04-25 20:13:06 | Re: Proposed patch - psql wraps at window width |
| Previous Message | Tom Lane | 2008-04-25 20:02:04 | Re: Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated values to an existing |