Re: [pgadmin-support] Issue with PgAdmin 4.13 and DATERANGE[]

Поиск
Список
Период
Сортировка
От Murtuza Zabuawala
Тема Re: [pgadmin-support] Issue with PgAdmin 4.13 and DATERANGE[]
Дата
Msg-id CAKKotZRmxjCFFE5t=+4rNecgy1yVCRCTmvSKBveLycz2UqrxsQ@mail.gmail.com
обсуждение исходный текст
Ответ на [pgadmin-support] Issue with PgAdmin 4.13 and DATERANGE[]  (Manuel Hegner <manuel.hegner@bakdata.com>)
Список pgadmin-support
Дерево обсуждения
Thanks for reporting the issue.


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Mar 15, 2017 at 8:12 PM, Manuel Hegner <manuel.hegner@bakdata.com> wrote:

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


В списке pgadmin-support по дате отправления: