Thanks everyone for the explanations. I posted a feature request for improved
enum manipulation in psql-general.
Dmitry Epstein | Developer
Allied Testing
www.alliedtesting.com
We Deliver Quality.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscr
Josh Kupershmidt writes:
>> Excerpts from depstein's message of mié sep 28 07:21:17 -0300 2011:
>>> Anyway, the procedure that we used (based on
>>> http://en.dklab.ru/lib/dklab_postgresql_enum/) does the necessary
>>> checks before removing enum values.
> Not exactly; that code is rife with race
On Wed, Sep 28, 2011 at 10:40 AM, Tom Lane wrote:
> Alvaro Herrera writes:
>> Excerpts from depstein's message of mié sep 28 07:21:17 -0300 2011:
>>> ALTER TYPE ... ADD VALUE does not work inside transaction blocks, period,
>>> whether they are executed as a multi-command string or one query at
On Wed, Sep 28, 2011 at 10:51 AM, Alvaro Herrera
wrote:
> Excerpts from depstein's message of mié sep 28 07:21:17 -0300 2011:
>> Anyway, the procedure that we used (based on
>> http://en.dklab.ru/lib/dklab_postgresql_enum/) does the necessary
>> checks before removing enum values.
Not exactly; th
Alvaro Herrera writes:
> Excerpts from depstein's message of mié sep 28 07:21:17 -0300 2011:
>> ALTER TYPE ... ADD VALUE does not work inside transaction blocks, period,
>> whether they are executed as a multi-command string or one query at a time.
>> Try it:
> The reason it is not allowed is
Excerpts from depstein's message of mié sep 28 07:21:17 -0300 2011:
> > -Original Message-
> > From: Merlin Moncure [mailto:mmonc...@gmail.com]
> > Sent: Tuesday, September 27, 2011 10:31 PM
> > > 1. We can use ALTER TYPE to add enum values, but there is no matching
> > command to remove v
On Wed, Sep 28, 2011 at 5:21 AM, wrote:
>> -Original Message-
>> From: Merlin Moncure [mailto:mmonc...@gmail.com]
>> Sent: Tuesday, September 27, 2011 10:31 PM
>> > 1. We can use ALTER TYPE to add enum values, but there is no matching
>> command to remove values, which makes this an incom
> -Original Message-
> From: Merlin Moncure [mailto:mmonc...@gmail.com]
> Sent: Tuesday, September 27, 2011 10:31 PM
> > 1. We can use ALTER TYPE to add enum values, but there is no matching
> command to remove values, which makes this an incomplete solution.
>
> you can manually delete fr
On Tue, Sep 27, 2011 at 5:06 AM, wrote:
> Hello,
>
> I've encountered some problems with the updated ENUM in PosgreSQL 9.1:
>
> 1. We can use ALTER TYPE to add enum values, but there is no matching command
> to remove values, which makes this an incomplete solution.
you can manually delete from
wrote:
> I've encountered some problems with the updated ENUM in PosgreSQL
> 9.1:
No matter how I tilt my head, I can't see any of those issues as
bugs. You have two feature requests and a question about how to
work around problems you're having with direct modifications to the
system tables.
Hello,
I've encountered some problems with the updated ENUM in PosgreSQL 9.1:
1. We can use ALTER TYPE to add enum values, but there is no matching command
to remove values, which makes this an incomplete solution.
2. "ALTER TYPE ... ADD cannot be executed from a function or multi-command
stri
11 matches
Mail list logo
