Обсуждение: [pgAdmin III] #278: Support for updating enums
#278: Support for updating enums ---------------------+------------------------------------------------------ Reporter: gleu | Owner: dpage Type: feature | Status: new Priority: minor | Milestone: Component: pgadmin | Version: 1.12 Keywords: type | Platform: all ---------------------+------------------------------------------------------ Seems it is as easy as doing an update on pg_enum. We should check that and, if it's true, make it work with pgAdmin. -- Ticket URL: <http://code.pgadmin.org/trac/ticket/278> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
#278: Support for updating enums ---------------------+------------------------------------------------------ Reporter: gleu | Owner: dpage Type: feature | Status: new Priority: minor | Milestone: Component: pgadmin | Version: 1.12 Keywords: type | Platform: all ---------------------+------------------------------------------------------ Comment(by thom): This is a bit vague, but I imagine it's referring to the fact that new values can be added to enums. If that's the case, this is already implemented: [http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=8dc53145d50ed2f65a112700c1390db79120f6d7] -- Ticket URL: <http://code.pgadmin.org/trac/ticket/278#comment:1> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
#278: Support for updating enums ---------------------+------------------------------------------------------ Reporter: gleu | Owner: dpage Type: feature | Status: new Priority: minor | Milestone: Component: pgadmin | Version: 1.12 Keywords: type | Platform: all ---------------------+------------------------------------------------------ Comment(by gleu): This is completely vague. The idea is that you don't need to be in 9.1 to update texts of an enum. The commit you're refering to is only for the support of the new syntax of ALTER TYPE targeting enum types. It's only available on 9.1. Moreover, it only allows one to add before or after an existing value. It doesn't allow someone to simply change a value of an enum. I created this ticket to allow the update of a value in an enum. Which, if I'm not wrong, should be an UPDATE in pg_enum. -- Ticket URL: <http://code.pgadmin.org/trac/ticket/278#comment:2> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III