Re: [DOCS] LOCAL and TIME ZONE in SET

2017-09-14 Thread Zbigniew Szmigiero
Hi, Thanks for explanation. Some information from my side. I am working on tool which create randomized SQL stream which covers all possible syntaxes for many different databases. The reason to do that is have possibility to check SQL parsing by DAM (Database activity monitoring) tools like

Re: [DOCS] LOCAL and TIME ZONE in SET

2017-09-12 Thread Steve Crawford
On Tue, Sep 12, 2017 at 11:07 AM, Zbigniew Szmigiero wrote: > > Hi Steve, > > You do not test syntax provided in my examples: > > 1. ALTER DATABASE name SET TIME ZONE to ‚timezone’ > > You used TIMEZONE instead of TIME ZONE - please check > > Your examples do not match the

Re: [DOCS] LOCAL and TIME ZONE in SET

2017-09-11 Thread David G. Johnston
On Mon, Sep 11, 2017 at 8:26 AM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > On Fri, Sep 8, 2017 at 1:05 PM, wrote: > >> The following documentation comment has been logged on the website: >> >> Page:

Re: [DOCS] LOCAL and TIME ZONE in SET

2017-09-11 Thread Steve Crawford
On Fri, Sep 8, 2017 at 1:05 PM, 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

[DOCS] LOCAL and TIME ZONE in SET

2017-09-11 Thread zszmigiero
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