pgsql: Make inherited LOCK TABLE perform access permission checks on pa

2020-02-17 Thread Fujii Masao
Make inherited LOCK TABLE perform access permission checks on parent table only. Previously, LOCK TABLE command through a parent table checked the permissions on not only the parent table but also the children tables inherited from it. This was a bug and inherited queries should perform access per

pgsql: Remove duplicated words in comments

2020-02-17 Thread Michael Paquier
Remove duplicated words in comments Author: Daniel Gustafsson Reviewed-by: Vik Fearing Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/958f9fb98da97a1d781a3766ea86bcdba3b216c5 Modified Fi

pgsql: Fix grammar in monitoring.sgml

2020-02-17 Thread Michael Paquier
Fix grammar in monitoring.sgml This is related to progress reporting for ANALYZE and partitioned tables. Author: Amit Langote Reviewed-by: Daniel Gustafsson, Julien Rouhaud Discussion: https://postgr.es/m/CA+HiwqGx6C=-bFTX=rymthyvm7ccsc3b1x8_6zh4uo41kvu...@mail.gmail.com Branch -- master D

pgsql: Teach pg_dump to dump comments on RLS policy objects.

2020-02-17 Thread Tom Lane
Teach pg_dump to dump comments on RLS policy objects. This was unaccountably omitted in the original RLS patch. The SQL syntax is basically the same as for comments on triggers, so crib code from dumpTrigger(). Per report from Marc Munro. Back-patch to all supported branches. Discussion: https:

pgsql: Teach pg_dump to dump comments on RLS policy objects.

2020-02-17 Thread Tom Lane
Teach pg_dump to dump comments on RLS policy objects. This was unaccountably omitted in the original RLS patch. The SQL syntax is basically the same as for comments on triggers, so crib code from dumpTrigger(). Per report from Marc Munro. Back-patch to all supported branches. Discussion: https:

pgsql: Teach pg_dump to dump comments on RLS policy objects.

2020-02-17 Thread Tom Lane
Teach pg_dump to dump comments on RLS policy objects. This was unaccountably omitted in the original RLS patch. The SQL syntax is basically the same as for comments on triggers, so crib code from dumpTrigger(). Per report from Marc Munro. Back-patch to all supported branches. Discussion: https:

pgsql: Teach pg_dump to dump comments on RLS policy objects.

2020-02-17 Thread Tom Lane
Teach pg_dump to dump comments on RLS policy objects. This was unaccountably omitted in the original RLS patch. The SQL syntax is basically the same as for comments on triggers, so crib code from dumpTrigger(). Per report from Marc Munro. Back-patch to all supported branches. Discussion: https:

pgsql: Teach pg_dump to dump comments on RLS policy objects.

2020-02-17 Thread Tom Lane
Teach pg_dump to dump comments on RLS policy objects. This was unaccountably omitted in the original RLS patch. The SQL syntax is basically the same as for comments on triggers, so crib code from dumpTrigger(). Per report from Marc Munro. Back-patch to all supported branches. Discussion: https:

pgsql: Teach pg_dump to dump comments on RLS policy objects.

2020-02-17 Thread Tom Lane
Teach pg_dump to dump comments on RLS policy objects. This was unaccountably omitted in the original RLS patch. The SQL syntax is basically the same as for comments on triggers, so crib code from dumpTrigger(). Per report from Marc Munro. Back-patch to all supported branches. Discussion: https:

pgsql: Fill in extraUpdatedCols in logical replication

2020-02-17 Thread Peter Eisentraut
Fill in extraUpdatedCols in logical replication The extraUpdatedCols field of the target RTE records which generated columns are affected by an update. This is used in a variety of places, including per-column triggers and foreign data wrappers. When an update was initiated by a logical replicat

pgsql: Optimize update of tables with generated columns

2020-02-17 Thread Peter Eisentraut
Optimize update of tables with generated columns When updating a table row with generated columns, only recompute those generated columns whose base columns have changed in this update and keep the rest unchanged. This can result in a significant performance benefit. The required information was

pgsql: Fill in extraUpdatedCols in logical replication

2020-02-17 Thread Peter Eisentraut
Fill in extraUpdatedCols in logical replication The extraUpdatedCols field of the target RTE records which generated columns are affected by an update. This is used in a variety of places, including per-column triggers and foreign data wrappers. When an update was initiated by a logical replicat