Re: Ticket 269: Add support for 9.1 ALTER TYPE new syntax for enum

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Ticket 269: Add support for 9.1 ALTER TYPE new syntax for enum
Date: 2010-10-30 04:56:19
Message-ID: 4CCBA573.9080906@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Le 29/10/2010 21:11, Guillaume Lelarge a écrit :
> [...]
> This patch adds support to the new ALTER TYPE syntax in 9.1 for enums.
>
> It's working great except one thing. If a user wants to add two labels,
> we're screwed because we can't do two "ALTER TYPE ... ADD" statements in
> the same query execution. Any idea how to solve this? the only way I
> found would be to disallow adding two labels at once but it results on a
> less interesting feature.
>

So I was wrong. The issue is that we can't issue this statement in a
explicit transaction. Any idea how to solve the "don't send begin/end
statements"?

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Thom Brown 2010-10-30 08:22:54 Re: Restore database form button
Previous Message Guillaume Lelarge 2010-10-30 04:32:04 Re: Restore database form button