Thread: Problem displaying intervals and timestamps with pgAdmin 4
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
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
Dave Page wrote: > Please log any additional issues directly at > https://redmine.postgresql.org/projects/pgadmin4/issues/new to save me > a step :-) Gladly. Wouldn't it be good to mention https://redmine.postgresql.org/projects/pgadmin4/ on https://www.pgadmin.org/support/ ? Yours, Laurenz Albe
On Mon, Jun 13, 2016 at 10:51 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote: > Dave Page wrote: >> Please log any additional issues directly at >> https://redmine.postgresql.org/projects/pgadmin4/issues/new to save me >> a step :-) > > Gladly. Thanks. > Wouldn't it be good to mention https://redmine.postgresql.org/projects/pgadmin4/ > on https://www.pgadmin.org/support/ ? Yeah, that was on my personal todo. It's done now :-) -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company