[DOCS] Default TIME ZONE in functions

2017-02-02 Thread forrest
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/7.4/static/functions-formatting.html Description: I find the date-time functions Table 9-20 and operators Table 9-29 discussions incomplete in specifying how time zones are handled on inputs

[DOCS] CREATE DOMAIN should also include an example of use with functions

2017-02-02 Thread postgresql
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/sql-createdomain.html Description: The documentation of CREATE DOMAIN currently describes how optional constraints can be useful for the fields of a table. There is no mention of f

[DOCS] Cross-references between DOMAIN and POLICY

2017-02-02 Thread postgresql
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/sql-createpolicy.html Description: Domains and row level policies are similar in the definition of a constraint with a CHECK expression. There should be a mention of domains on th

Re: [DOCS] complete 'C' trigger example needs fmgr.h

2017-02-02 Thread Peter Eisentraut
On 1/12/17 12:59 PM, Euler Taveira wrote: > On 11-01-2017 22:05, mthrockmor...@hme.com wrote: >> The following documentation comment has been logged on the website: >> >> Page: https://www.postgresql.org/docs/9.6/static/trigger-example.html >> Description: >> >> seems like the complete 'C' trigger

Re: [DOCS] CentOS 7 incorrect installation location

2017-02-02 Thread Devrim Gündüz
Hi, On Wed, 2017-01-18 at 20:24 +, gregory.r.m...@gmail.com wrote: > The make command in the tutorial throws an error concerning the pgxs path. > "pg_config --pgxs" returns "/usr/lib/pgxs/...", when the > actual path is > "/usr/pgsql-9.6/lib/pgxs/... I think both CentOS and community RPMs ar

Re: [DOCS] instr function with negative parameter

2017-02-02 Thread Peter Eisentraut
On 1/17/17 3:49 PM, mmalorod...@usgs.gov wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.4/static/plpgsql-porting.html > Description: > > instr function with negative parameter does not return the same result as in > Oracle

Re: [DOCS] CentOS 7 incorrect installation location

2017-02-02 Thread Peter Eisentraut
On 1/18/17 3:24 PM, gregory.r.m...@gmail.com wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.6/static/tutorial-sql-intro.html > Description: > > The make command in the tutorial throws an error concerning the pgxs path. > "p

Re: [DOCS] CREATE_REPLICATION_SLOT exported snapshot

2017-02-02 Thread Peter Eisentraut
On 9/11/16 6:23 AM, Marko Tiikkaja wrote: > There's a brief mention of CREATE_REPLICATION_SLOT exporting a snapshot > here: > > https://www.postgresql.org/docs/devel/static/logicaldecoding-explanation.html#AEN71570 > > but how to access the snapshot identifier is not documented anywhere. > So

Re: [DOCS] Encoding change actually works)

2017-02-02 Thread Peter Eisentraut
On 6/27/16 4:24 AM, marc+pg...@milestonerdl.com wrote: > https://www.postgresql.org/docs/9.4/static/sql-createdatabase.html > > Says: > CREATE DATABASE music ENCODING 'LATIN1' TEMPLATE template0; > > that did not work. Whereas: > > CREATE DATABASE music ENCODING 'LATIN1' TEMPLATE template0