Mistake in documentation for CREATE STATISTICS

2019-06-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-createstatistics.html Description: The example on https://www.postgresql.org/docs/11/sql-createstatistics.html seems wrong: instead of "EXPLAIN ANALYZE SELECT ..." it should say "EXPLA

ATTACH/DETACH partitions and locking

2019-06-13 Thread Pavel Luzanov
Hello, According to patch[1] and after playing with v12 beta1 I think that this item can be dropped from "5.11.3. Implementation Using Inheritance" section of v12 docs: "Some operations require a stronger lock when using declarative partitioning than when using table inheritance. For example

Re: ATTACH/DETACH partitions and locking

2019-06-13 Thread Alvaro Herrera
On 2019-Jun-13, Pavel Luzanov wrote: > Hello, > > According to patch[1] and after playing with v12 beta1 I think that this > item can be dropped from "5.11.3. Implementation Using Inheritance" section > of v12 docs: > > "Some operations require a stronger lock when using declarative partitioning

More obvious clarification is needed about how RLS interacts with views

2019-06-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-createpolicy.html Description: It's not clear enough from reading the documentation on RLS security policy that schema designers need to pay special attention to views and their owners