Re: Problem displaying intervals and timestamps with pgAdmin 4

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Problem displaying intervals and timestamps with pgAdmin 4
Дата
Msg-id CA+OCxoyCUy93cfNNM-iBxkuW4vTMQ73_Qdh5aAS-niYJrFd8Pw@mail.gmail.com
обсуждение исходный текст
Ответ на Problem displaying intervals and timestamps with pgAdmin 4  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Ответы Re: Problem displaying intervals and timestamps with pgAdmin 4  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgadmin-support
Thanks - issue #1352 created.

Please log any additional issues directly at
https://redmine.postgresql.org/projects/pgadmin4/issues/new to save me
a step :-)



On Mon, Jun 13, 2016 at 10:32 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
> I am using pgAdmin 4 1.0-beta1 (downloaded from pgadmin.org) on Windows 7.
>
> I get an error message like this:
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
> <title>500 Internal Server Error</title>
> <h1>Internal Server Error</h1>
> <p>The server encountered an internal error and was unable to complete your request.  Either the server is overloaded
orthere is an error in the application.</p>
 
>
> When I SELECT any interval or a date/timestamp/timestamptz value before Christ.
>
> Examples:
>
>   SELECT DATE '0044-03-15 BC';
>
>   SELECT TIMESTAMP '0044-03-15 10:00:00 BC';
>
>   SELECT TIMESTAMPTZ '0044-03-15 10:00:00+02 BC';
>
>   SELECT INTERVAL '15 minutes';
>
> Also, when displaying a timestamptz value, the time part gets lost:
>
>   SELECT TIMESTAMPTZ '2016-03-15 10:00:00+02 AD';
> displays
>   2016-03-15T00:00:00Z
>
> Yours,
> Laurenz Albe
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Problem displaying intervals and timestamps with pgAdmin 4
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Problem displaying intervals and timestamps with pgAdmin 4