On 2012-12-19 16:51:32 +0100, Bernhard Schrader wrote: > Hello again, > > well, still everything is working. > > What information do you need to get into this issue? > > Well, so far i can say, we dont use ALTER TYPE ADD VALUE. We use some more > or less changed enum_add and enum_del (Which are appended at the end) to be > able to change enums within transactions.
That explains everything. You *CANNOT* do that. There are some pretty fundamental reasons why you are not allowed to add enums in a transaction. And even more reasons why deleting from enums isn't allowed at all. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
