Re: [DOCS] LOCAL and TIME ZONE in SET
| От | Steve Crawford |
|---|---|
| Тема | Re: [DOCS] LOCAL and TIME ZONE in SET |
| Дата | |
| Msg-id | CAEfWYyzMhvMMnt7wY+FNO197fUr6LXUWpqJ3FygefFL5ZhsbVQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | [DOCS] LOCAL and TIME ZONE in SET (zszmigiero@gmail.com) |
| Ответы |
Re: [DOCS] LOCAL and TIME ZONE in SET
|
| Список | pgsql-docs |
On Fri, Sep 8, 2017 at 1:05 PM, <zszmigiero@gmail.com> wrote:
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
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
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
В списке pgsql-docs по дате отправления: