Thread: [pgAdmin III] #175: Column properties: uncalled attempt to "change" array data types
[pgAdmin III] #175: Column properties: uncalled attempt to "change" array data types
From
"pgAdmin Trac"
Date:
#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
Re: [pgAdmin III] #175: Column properties: uncalled attempt to "change" array data types
From
"pgAdmin Trac"
Date:
#175: Column properties: uncalled attempt to "change" array data types
---------------------------------+------------------------------------------
Reporter: brsa | Owner: gleu
Type: bug | Status: assigned
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: browser, properties | Platform: all
---------------------------------+------------------------------------------
Changes (by gleu):
* owner: dpage => gleu
* status: new => assigned
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/175#comment:1>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
Re: [pgAdmin III] #175: Column properties: uncalled attempt to "change" array data types
From
"pgAdmin Trac"
Date:
#175: Column properties: uncalled attempt to "change" array data types
----------------------+-----------------------------------------------------
Reporter: brsa | Owner: gleu
Type: bug | Status: closed
Priority: minor | Milestone: 1.10.3
Component: pgadmin | Version: 1.10
Resolution: fixed | Keywords: browser, properties
Platform: all |
----------------------+-----------------------------------------------------
Changes (by gleu):
* status: assigned => closed
* resolution: => fixed
* milestone: => 1.10.3
Comment:
Fixed in r8306 and r8307.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/175#comment:2>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III