Geography showing cryptic type

[robe]

I hope this has been fixed since. I just got around to stress testing the 12/30 build I did and when I create a geography table and look at the CREATE TABLE in pgadmin it looks like So for example if I created a table as

CREATE TABLE pgis_geoggarden(gid serial NOT NULL, the_geog geography(POINT));

When I relook at it, it looks like this: CREATE TABLE pgis_geoggarden (

gid serial NOT NULL, the_geog geography(1107456)

);

Can you check and see if it shows similar anomaly. I don't recall it looking like this before. Though

SELECT * FROM geography_columns

looks fine.

I'm trying to recall if last time I looked at this was with PgAdmin 1.10 and now I'm running 1.10

[robe]

I'll leave this open until I verify, but I suspect this may be a bug in PgAdmin III 1.10.1 rather than PostGIS in which case I'll push to them. I'll have to dig out my old PgAdminIII install to confirm unless someone has a pre-1.10.1 installed to confirm it looks okay. I don't think I saw this behavior when I had PgAdmin 1.10.0 installed.

I looked at it via phppgAdmin, and it correctly shows the types.

[robe]

Refer to: ​http://code.pgadmin.org/trac/ticket/125

Guillaume is working on it. Thanks Guillaume.

[robe]

This was a bug in pgAdmin and has since been fixed in I think pgAdmin 1.10 or 1.11. Can't recall which.