Ticket #175 (closed bug: fixed)
Column properties: uncalled attempt to "change" array data types
| Reported by: | brsa | Owned by: | gleu |
|---|---|---|---|
| Priority: | minor | Milestone: | 1.10.3 |
| Component: | pgadmin | Version: | 1.10 |
| Keywords: | browser, properties | Cc: | |
| Platform: | all |
Description
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';
