[pgAdmin III] #175: Column properties: uncalled attempt to "change" array data types - Mailing list pgadmin-hackers

#175: Column properties: uncalled attempt to "change" array data types
---------------------------------+------------------------------------------
 Reporter:  brsa                 |       Owner:  dpage
     Type:  bug                  |      Status:  new  
 Priority:  minor                |   Milestone:       
Component:  pgadmin              |     Version:  1.10 
 Keywords:  browser, properties  |    Platform:  all  
---------------------------------+------------------------------------------
 Testing v.1.10.2 with Guillaume's pgamin3 from Apr, 17. on Win XP Home.
 Legacy v.1.10.2 has the same bug.

 When I try to change anything in the properties dialog of a column type
 integer[] (or _any_ ARRAY type), pgAdmin tries to "change" the data type
 as well - which results in an error msg., if objects like a view depend on
 it.

 The root of the problem might be, that two different notations for array
 types are used, so that a change is detected, where nothing has changed?
 (Just guessing.)
     text[]
     _text

 Demo:
 CREATE TABLE test(id serial primary key,  test text[]);

 - Create a VIEW using the column "test.test" and you will get an error
 msg. below.
 - Now change anything in the properties dialog of the array column, for
 instance the comment.

 -- What pgAdmin should send to the server:
 COMMENT ON COLUMN test.test IS 'Foo';

 -- What pgAdmin actually sends:
 ALTER TABLE test ALTER test TYPE text[];
 COMMENT ON COLUMN test.test IS 'Foo';

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/175>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III