| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | zszmigiero(at)gmail(dot)com |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: LOCAL and TIME ZONE in SET |
| Date: | 2017-09-11 15:26:54 |
| Message-ID: | CAEfWYyzMhvMMnt7wY+FNO197fUr6LXUWpqJ3FygefFL5ZhsbVQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Fri, Sep 8, 2017 at 1:05 PM, <zszmigiero(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2017-09-11 16:02:51 | Re: LOCAL and TIME ZONE in SET |
| Previous Message | Daniel Gustafsson | 2017-09-11 15:25:38 | XMLTABLE default namespace in docs |