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

[pgAdmin III] #125: PgAdmin not displaying typmod column types correctly in create or display

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #125: PgAdmin not displaying typmod column types correctly in create or display
Date: 2010-01-05 22:14:42
Message-ID: 051.7a59412721a5f309d3c2fd637a0228fc@code.pgadmin.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
#125: PgAdmin not displaying typmod column types correctly in create or display
------------------------+---------------------------------------------------
 Reporter:  Regina Obe  |       Owner:  gleu
     Type:  bug         |      Status:  new 
 Priority:  minor       |   Milestone:      
Component:  pgadmin     |     Version:  1.10
 Keywords:  column      |    Platform:  all 
------------------------+---------------------------------------------------
 I assume this is a PgAdmin III bug, but I could be wrong.
 I'm using PgAdmin 1.10.1 on Windows, but seems to be an issue with even
 1.8 since I tried on that too.

 The upcoming PostGIS 1.5 has a new type called geography that uses the
 Typmod functionality introduced in 8.3.

 I'm guessing this is a display bug in how PgAdmin is displaying typmod
 types.

 Details here

 http://trac.osgeo.org/postgis/ticket/368

 What is interesting is if I do a select of the table in question, the
 geography header shows correctly as

 geography(Point,4326) or geography(Linestring,4326)

 so it seems its just in the

 CREATE TABLE ... that displays on the side panel of PgAdmin or when you
 select generate create script.


 I could of sworn I saw it right at some point before (but installing a
 previous experimental build of PostGIS behaved the same). Perhaps I was
 always focusing on the display of the SELECT... of its display in
 phppgadmin which correctly displays the type.

 In case you need to test, have windows experimental builds here
 http://www.postgis.org/download/windows/experimental.php

-- 
Ticket URL: <http://code.pgadmin.org/trac/ticket/125>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

Responses

pgadmin-hackers by date

Next:From: pgAdmin TracDate: 2010-01-07 00:07:31
Subject: Re: [pgAdmin III] #125: PgAdmin not displaying typmod column types correctly in create or display
Previous:From: pgAdmin TracDate: 2010-01-05 22:10:18
Subject: [pgAdmin III] #124: Support for the new "ALTER TABLESPACE name SET/RESET" statement

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