Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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

Responses

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2010-04-26 12:39:07
Subject: Re: Issues with my patch on the groups of servers
Previous:From: Dave PageDate: 2010-04-26 11:03:30
Subject: Re: PATCH: Ticket#99: Support for Default Privileges

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group