Issue with PgAdmin 4.13 and DATERANGE[]

From: Manuel Hegner <manuel(dot)hegner(at)bakdata(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Issue with PgAdmin 4.13 and DATERANGE[]
Date: 2017-03-15 14:42:02
Message-ID: 50932184-5f9f-d31a-7d38-d423b72ec446@bakdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I found an issue in PgAdmin. It seems the UI is not able to render
arrays of dateranges and thus displays nothing at all.

* Platform: MacOS
* Languag: English
* Distribution: binary
* Version: 4.13

To reproduce:

1. CREATE TABLE dates_test(dates DATERANGE[]);
2. INSERT INTO dates_test VALUES
('{"(2016-01-01,2017-01-01)"}'::DATERANGE[]);
3. SELECT dates FROM dates_test;
* shows nothing in Data Output in pgAdmin
4. SELECT dates::VARCHAR FROM public.dates_test;
* works as expected and shows the one inserted row as
{"[2016-01-02,2017-01-01)"}

A coworker on Windows 10 has the same problem.

Regards,
Manuel Hegner

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Derek Ealy 2017-03-15 14:50:44 Re: internal server error on password change
Previous Message Murtuza Zabuawala 2017-03-15 07:43:36 Re: internal server error on password change