[BUGS] BUG #14568: timezone WIT is not support - Mailing list pgsql-bugs

From xdl@logossmartcard.com
Subject [BUGS] BUG #14568: timezone WIT is not support
Date
Msg-id 20170224122127.1518.50591@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14568: timezone WIT is not support  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14568
Logged by:          xiang liu
Email address:      xdl@logossmartcard.com
PostgreSQL version: 9.5.2
Operating system:   rhel 6.8
Description:

time WIT is not support by timestamp, eg

sat=# select 'Fri Feb 24 18:59:57.342802 2017 WIT'::timestamp;
ERROR:  invalid input syntax for type timestamp: "Fri Feb 24 18:59:57.342802
2017 WIT"
LINE 1: select 'Fri Feb 24 18:59:57.342802 2017 WIT'::timestamp;

WIT is defined in pg_timezone_names but not in pg_timezone_abbrevs.



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Zbigniew Szot
Date:
Subject: Re: [BUGS] BUG #14565: query planner does not use partial index inpartiton if query is performed on multiple partitions
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14568: timezone WIT is not support