On Fri, Sep 8, 2017 at 1:05 PM, <zszmigi...@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 "ALTER DATABASE name TIME ZONE ..." is rejected > > THE "ALTER DATABASE name TIMEZONE TO LOCAL" 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
