Re: Documentation: 21.5. Default Roles

2020-02-05 Thread Bruce Momjian
On Tue, Feb 4, 2020 at 11:31:19AM -0500, Jonathan Katz wrote: > > Using this feature to handle the rename of a file *between* major > > versions, thus leaving the changes in master, should be safe (as long > > as we add an entry to that table in pgweb). > > > > As for back branches, I think we ha

RETURNING does not explain evaluation context for subqueries

2020-02-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/dml-returning.html Description: In the docs explaining RETURNING https://www.postgresql.org/docs/11/dml-returning.html there is no mention of the fact that a nested sub-select in the RETUR

Re: Users/Roles do not align.

2020-02-05 Thread Stephen Frost
Greetings, * Jürgen Purtz (juer...@purtz.de) wrote: > >Based on this, I believe Section 5.9 should read: > >`A PostgreSQL database cluster contains one or more named databases. Roles > >are shared across the entire cluster, but no other data is shared across > >databases. Any given client connecti

Wrong insert before trigger examples

2020-02-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-partitioning.html Description: Hi, I just noticed that the example in 5.11.3.1. Point 5 contains an "before insert trigger" which will not work anymore (I think since Postgres 12). Th