Ticket #175 (closed bug: fixed)

Opened 22 months ago

Last modified 22 months ago

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';

Change History

Changed 22 months ago by gleu

  • status changed from new to assigned
  • owner changed from dpage to gleu

Changed 22 months ago by gleu

  • status changed from assigned to closed
  • resolution set to fixed
  • milestone set to 1.10.3

Fixed in r8306 and r8307.

Note: See TracTickets for help on using tickets.