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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Reply via email to