Re: [DOCS] LOCAL and TIME ZONE in SET
| От | David G. Johnston |
|---|---|
| Тема | Re: [DOCS] LOCAL and TIME ZONE in SET |
| Дата | |
| Msg-id | CAKFQuwZgpkoDgxCPp-2Kcmie6LMX5F0vumG8Z29qXMkbUM=rVg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [DOCS] LOCAL and TIME ZONE in SET (Steve Crawford <scrawford@pinpointresearch.com>) |
| Список | pgsql-docs |
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 "ALTER DATABASE name TIME ZONE ..." is rejected
THE "ALTER DATABASE name TIMEZONE TO LOCAL" is rejected
Please update documentation or provide correct syntaxIt 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
More specifically the first listed syntax only applies if the inherent database "option" you wish to set is one of:
ALLOW_CONNECTIONS allowconn
CONNECTION LIMIT connlimit
IS_TEMPLATE istemplate
What you want to do is setup a default User-Database Configuration (GUC) value (which in this case applies to all users connecting to this database); which is what the last 4 syntax specifications pertain to - as noted in the description section on that page.
18.1.3 describes this dynamic in more detail:
David J.
В списке pgsql-docs по дате отправления: