pgsql: psql \dX: list extended statistics objects

2021-01-16 Thread Tomas Vondra
psql \dX: list extended statistics objects The new command lists extended statistics objects, possibly with their sizes. All past releases with extended statistics are supported. Author: Tatsuro Yamada Reviewed-by: Julien Rouhaud, Alvaro Herrera, Tomas Vondra Discussion: https://postgr.es/m/c027

pgsql: Documenation fixups for replication protocol.

2021-01-16 Thread Jeff Davis
Documenation fixups for replication protocol. There is no CopyResponse message; it should be CopyOutResponse. Also, if there is no WAL to stream, the server does not immediately send a CommandComplete; it's a historical timeline, so it will send a response tuple first. Discussion: https://postg

pgsql: Prevent excess SimpleLruTruncate() deletion.

2021-01-16 Thread Noah Misch
Prevent excess SimpleLruTruncate() deletion. Every core SLRU wraps around. With the exception of pg_notify, the wrap point can fall in the middle of a page. Account for this in the PagePrecedes callback specification and in SimpleLruTruncate()'s use of said callback. Update each callback implem

pgsql: Fix pg_dump for GRANT OPTION among initial privileges.

2021-01-16 Thread Noah Misch
Fix pg_dump for GRANT OPTION among initial privileges. The context is an object that no longer bears some aclitem that it bore initially. (A user issued REVOKE or GRANT statements upon the object.) pg_dump is forming SQL to reproduce the object ACL. Since initdb creates no ACL bearing GRANT OPTI

pgsql: Prevent excess SimpleLruTruncate() deletion.

2021-01-16 Thread Noah Misch
Prevent excess SimpleLruTruncate() deletion. Every core SLRU wraps around. With the exception of pg_notify, the wrap point can fall in the middle of a page. Account for this in the PagePrecedes callback specification and in SimpleLruTruncate()'s use of said callback. Update each callback implem

pgsql: Prevent excess SimpleLruTruncate() deletion.

2021-01-16 Thread Noah Misch
Prevent excess SimpleLruTruncate() deletion. Every core SLRU wraps around. With the exception of pg_notify, the wrap point can fall in the middle of a page. Account for this in the PagePrecedes callback specification and in SimpleLruTruncate()'s use of said callback. Update each callback implem

pgsql: Prevent excess SimpleLruTruncate() deletion.

2021-01-16 Thread Noah Misch
Prevent excess SimpleLruTruncate() deletion. Every core SLRU wraps around. With the exception of pg_notify, the wrap point can fall in the middle of a page. Account for this in the PagePrecedes callback specification and in SimpleLruTruncate()'s use of said callback. Update each callback implem

pgsql: Fix pg_dump for GRANT OPTION among initial privileges.

2021-01-16 Thread Noah Misch
Fix pg_dump for GRANT OPTION among initial privileges. The context is an object that no longer bears some aclitem that it bore initially. (A user issued REVOKE or GRANT statements upon the object.) pg_dump is forming SQL to reproduce the object ACL. Since initdb creates no ACL bearing GRANT OPTI

pgsql: Prevent excess SimpleLruTruncate() deletion.

2021-01-16 Thread Noah Misch
Prevent excess SimpleLruTruncate() deletion. Every core SLRU wraps around. With the exception of pg_notify, the wrap point can fall in the middle of a page. Account for this in the PagePrecedes callback specification and in SimpleLruTruncate()'s use of said callback. Update each callback implem

pgsql: Fix pg_dump for GRANT OPTION among initial privileges.

2021-01-16 Thread Noah Misch
Fix pg_dump for GRANT OPTION among initial privileges. The context is an object that no longer bears some aclitem that it bore initially. (A user issued REVOKE or GRANT statements upon the object.) pg_dump is forming SQL to reproduce the object ACL. Since initdb creates no ACL bearing GRANT OPTI

pgsql: Fix pg_dump for GRANT OPTION among initial privileges.

2021-01-16 Thread Noah Misch
Fix pg_dump for GRANT OPTION among initial privileges. The context is an object that no longer bears some aclitem that it bore initially. (A user issued REVOKE or GRANT statements upon the object.) pg_dump is forming SQL to reproduce the object ACL. Since initdb creates no ACL bearing GRANT OPTI

pgsql: Prevent excess SimpleLruTruncate() deletion.

2021-01-16 Thread Noah Misch
Prevent excess SimpleLruTruncate() deletion. Every core SLRU wraps around. With the exception of pg_notify, the wrap point can fall in the middle of a page. Account for this in the PagePrecedes callback specification and in SimpleLruTruncate()'s use of said callback. Update each callback implem

pgsql: Fix pg_dump for GRANT OPTION among initial privileges.

2021-01-16 Thread Noah Misch
Fix pg_dump for GRANT OPTION among initial privileges. The context is an object that no longer bears some aclitem that it bore initially. (A user issued REVOKE or GRANT statements upon the object.) pg_dump is forming SQL to reproduce the object ACL. Since initdb creates no ACL bearing GRANT OPTI

pgsql: Fix pg_dump for GRANT OPTION among initial privileges.

2021-01-16 Thread Noah Misch
Fix pg_dump for GRANT OPTION among initial privileges. The context is an object that no longer bears some aclitem that it bore initially. (A user issued REVOKE or GRANT statements upon the object.) pg_dump is forming SQL to reproduce the object ACL. Since initdb creates no ACL bearing GRANT OPTI

pgsql: Prevent excess SimpleLruTruncate() deletion.

2021-01-16 Thread Noah Misch
Prevent excess SimpleLruTruncate() deletion. Every core SLRU wraps around. With the exception of pg_notify, the wrap point can fall in the middle of a page. Account for this in the PagePrecedes callback specification and in SimpleLruTruncate()'s use of said callback. Update each callback implem