Обсуждение: [pgAdmin III] #278: Support for updating enums

Поиск
Список
Период
Сортировка

[pgAdmin III] #278: Support for updating enums

От
"pgAdmin Trac"
Дата:
#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

Re: [pgAdmin III] #278: Support for updating enums

От
"pgAdmin Trac"
Дата:
#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

Re: [pgAdmin III] #278: Support for updating enums

От
"pgAdmin Trac"
Дата:
#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