Ticket #125 (closed bug: fixed)
PgAdmin not displaying typmod column types correctly in create or display
| Reported by: | Regina Obe | Owned by: | gleu |
|---|---|---|---|
| Priority: | minor | Milestone: | 1.10.2 |
| Component: | pgadmin | Version: | 1.10 |
| Keywords: | column | Cc: | |
| Platform: | all |
Description
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
Attachments
-
ticket125_v1.patch
(1.6 KB) - added by gleu
3 years ago.
- v1 patch
