Opened 8 years ago

Closed 6 years ago

#368 closed defect (wontfix)

Geography showing cryptic type

Reported by: robe Owned by: pramsey
Priority: medium Milestone: PostGIS 1.5.2
Component: postgis Version: trunk
Keywords: Cc:


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

Change History (3)

comment:1 Changed 8 years ago by robe

Milestone: PostGIS 1.5.0PostGIS Future

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.

comment:2 Changed 8 years ago by robe

Refer to:

Guillaume is working on it. Thanks Guillaume.

comment:3 Changed 6 years ago by robe

Milestone: PostGIS FuturePostGIS 1.5.2
Resolution: wontfix
Status: newclosed

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

Note: See TracTickets for help on using tickets.