Problem displaying intervals and timestamps with pgAdmin 4

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: Problem displaying intervals and timestamps with pgAdmin 4
Date: 2016-06-13 09:32:01
Message-ID: A737B7A37273E048B164557ADEF4A58B5385F029@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2016-06-13 09:48:33 Re: Problem displaying intervals and timestamps with pgAdmin 4
Previous Message Dave Page 2016-06-13 09:31:13 Re: Foreign table column options in pgAdmin 4