Re: [pgadmin-support] postgis geometry type not displayed correctly

From: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
To: Richard Greenwood <richard(dot)greenwood(at)gmail(dot)com>
Cc: Dave Page <dpage(at)pgadmin(dot)org>, pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: [pgadmin-support] postgis geometry type not displayed correctly
Date: 2017-07-18 03:43:07
Message-ID: CAFOhELfar24CSWhZ6nFzYcMkGSzHD052BOvCYwkVDvouPZOybg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Richard,

On Tue, Jul 18, 2017 at 5:13 AM, Richard Greenwood <
richard(dot)greenwood(at)gmail(dot)com> wrote:

> In 1.6 a PostGIS geometry column now shows as "Geometry" in both the
> Table>SQL tab and the Column>SQL tab. Thanks for that. But in psql and
> pgAdmin3 it would be shown as e.g. "MultiPolygon, 3739". It would be very
> helpful if pgAdmin4 could also show that level of detail.
>
> Thanks for reporting. This issue was already fixed into 1.6 but it seems
like this has been broken partially.
I have reopened the case. https://redmine.postgresql.org/issues/2324

> Thanks,
> Rich
>
>
> On Tue, May 30, 2017 at 11:57 PM, Khushboo Vashi <
> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>
>>
>> On Tue, May 30, 2017 at 8:51 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>
>>> Khushboo, can you look into this please (and log and RM to go with it
>>> if required)?
>>>
>>> Sure, I will work on this after finishing my current RM #2425
>> <https://redmine.postgresql.org/issues/2425> .
>>
>>> Thanks.
>>>
>>> On Tue, May 30, 2017 at 4:09 PM, Richard Greenwood
>>> <richard(dot)greenwood(at)gmail(dot)com> wrote:
>>> > I don't know if this question belongs on this list or the postgis
>>> list. In
>>> > psql and pgAdmin3 a postgis geometry column is show as e.g.
>>> >
>>> > Column | Type
>>> > ---------------+---------------------
>>> > polygeom | geometry(MultiPolygon,3739)
>>> >
>>> > however in pgAdmin4 it's show as:
>>> >
>>> > polygeom geometry(957204)
>>> >
>>> > Like "957204" is not being translated to "MultiPolygon, 3739". Any
>>> ideas or
>>> > should I be asking this on the postgis list?
>>> >
>>> > Thanks,
>>> > Rich
>>> >
>>> > --
>>> > Richard W. Greenwood, PLS
>>> > www.greenwoodmap.com
>>>
>>>
>>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>
>>
>
>
> --
> Richard W. Greenwood, PLS
> www.greenwoodmap.com
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Shirley Wang 2017-07-18 13:30:47 New font for testing in Query Editor tool
Previous Message Richard Greenwood 2017-07-17 23:43:42 Re: [pgadmin-support] postgis geometry type not displayed correctly