Problem displaying intervals and timestamps with pgAdmin 4 - Mailing list pgadmin-support

From Albe Laurenz
Subject Problem displaying intervals and timestamps with pgAdmin 4
Date
Msg-id A737B7A37273E048B164557ADEF4A58B5385F029@ntex2010i.host.magwien.gv.at
Whole thread Raw
Responses Re: Problem displaying intervals and timestamps with pgAdmin 4  (Dave Page <dpage@pgadmin.org>)
List 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
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

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Foreign table column options in pgAdmin 4
Next
From: Dave Page
Date:
Subject: Re: Problem displaying intervals and timestamps with pgAdmin 4