BUG #14568: timezone WIT is not support

From: xdl(at)logossmartcard(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14568: timezone WIT is not support
Date: 2017-02-24 12:21:27
Message-ID: 20170224122127.1518.50591@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14568
Logged by: xiang liu
Email address: xdl(at)logossmartcard(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-02-24 17:04:13 Re: BUG #14568: timezone WIT is not support
Previous Message Zbigniew Szot 2017-02-24 11:13:38 Re: BUG #14565: query planner does not use partial index in partiton if query is performed on multiple partitions