Re: [DOCS] LOCAL and TIME ZONE in SET

On Fri, Sep 8, 2017 at 1:05 PM, <zszmigiero@gmail.com> wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/sql-alterdatabase.html
Description:

The &quot;ALTER DATABASE name TIME ZONE ...&quot; is rejected

THE &quot;ALTER DATABASE name TIMEZONE TO LOCAL&quot; is rejected

Please update documentation or provide correct syntax

It works as described in the documentation:

steve=> alter database steve set timezone to local;  
ERROR:  must be owner of database steve

postgres=# alter database steve set timezone to 'US/Pacific';  
ALTER DATABASE
postgres=# alter database steve set timezone to default;      
ALTER DATABASE

Cheers,
Steve