From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Problem displaying intervals and timestamps with pgAdmin 4 |
Date: | 2016-06-13 09:48:33 |
Message-ID: | CA+OCxoyCUy93cfNNM-iBxkuW4vTMQ73_Qdh5aAS-niYJrFd8Pw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)albe(at)wien(dot)gv(dot)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 or there 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(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2016-06-13 09:51:44 | Re: Problem displaying intervals and timestamps with pgAdmin 4 |
Previous Message | Albe Laurenz | 2016-06-13 09:32:01 | Problem displaying intervals and timestamps with pgAdmin 4 |