From: | "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org> |
---|---|
To: | |
Cc: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | [pgAdmin III] #175: Column properties: uncalled attempt to "change" array data types |
Date: | 2010-04-26 12:26:53 |
Message-ID: | 045.90871bacb6502ccd6c793feea57e2ad9@code.pgadmin.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-04-26 12:39:07 | Re: Issues with my patch on the groups of servers |
Previous Message | Dave Page | 2010-04-26 11:03:30 | Re: PATCH: Ticket#99: Support for Default Privileges |