BUG #14511: Set timezone to local

From: adrian(dot)klaver(at)aklaver(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14511: Set timezone to local
Date: 2017-01-24 16:13:32
Message-ID: 20170124161332.1431.51405@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: 14511
Logged by: Adrian Klaver
Email address: adrian(dot)klaver(at)aklaver(dot)com
PostgreSQL version: 9.5.5
Operating system: Linux openSUSE 42.2
Description:

test=> select version();
version

-------------------------------------------------------------------------------------
PostgreSQL 9.5.5 on x86_64-pc-linux-gnu, compiled by gcc (SUSE Linux)
4.8.5, 64-bit
(1 row)

test=> set timezone = DEFAULT;
SET

test=> set timezone = LOCAL;
ERROR: invalid value for parameter "TimeZone": "local"

test=> set time zone LOCAL;
SET

The docs:

https://www.postgresql.org/docs/9.5/static/sql-set.html

say the last two commands should yield the same result. Not sure if this
error in docs or code.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message vojta.rylko 2017-01-24 17:25:05 BUG #14512: Backslashes in LIKE
Previous Message John McKown 2017-01-24 15:03:18 Re: BUG #14510: found encoding issue