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

Поиск
Список
Период
Сортировка
От Manuel Hegner
Тема [pgadmin-support] Issue with PgAdmin 4.13 and DATERANGE[]
Дата
Msg-id 50932184-5f9f-d31a-7d38-d423b72ec446@bakdata.com
обсуждение исходный текст
Ответы Re: [pgadmin-support] Issue with PgAdmin 4.13 and DATERANGE[]
Список 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

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

Предыдущее
От: Murtuza Zabuawala
Дата:
Сообщение: Re: [pgadmin-support] internal server error on password change
Следующее
От: Derek Ealy
Дата:
Сообщение: Re: [pgadmin-support] internal server error on password change