[pgAdmin III] #175: Column properties: uncalled attempt to "change" array data types

#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