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

#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