Ticket #368 (closed defect: wontfix)

Opened 5 years ago

Last modified 4 years ago

Geography showing cryptic type

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

Description

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

Changed 5 years ago by robe

  • milestone changed from PostGIS 1.5.0 to PostGIS 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.

Changed 5 years ago by robe

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

Guillaume is working on it. Thanks Guillaume.

Changed 4 years ago by robe

  • status changed from new to closed
  • resolution set to wontfix
  • milestone changed from PostGIS Future to PostGIS 1.5.2

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.