pgsql: Fix buggy logic in isTempNamespaceInUse()

2020-01-14 Thread Michael Paquier
Fix buggy logic in isTempNamespaceInUse() The logic introduced in this routine as of 246a6c8 would report an incorrect result when a session calls it to check if the temporary namespace owned by the session is in use or not. It is possible to optimize more the routine in this case to avoid a

pgsql: Fix buggy logic in isTempNamespaceInUse()

2020-01-14 Thread Michael Paquier
Fix buggy logic in isTempNamespaceInUse() The logic introduced in this routine as of 246a6c8 would report an incorrect result when a session calls it to check if the temporary namespace owned by the session is in use or not. It is possible to optimize more the routine in this case to avoid a

pgsql: Fix buggy logic in isTempNamespaceInUse()

2020-01-14 Thread Michael Paquier
Fix buggy logic in isTempNamespaceInUse() The logic introduced in this routine as of 246a6c8 would report an incorrect result when a session calls it to check if the temporary namespace owned by the session is in use or not. It is possible to optimize more the routine in this case to avoid a

pgsql: Introduce IndexAM fields for parallel vacuum.

2020-01-14 Thread Amit Kapila
Introduce IndexAM fields for parallel vacuum. Introduce new fields amusemaintenanceworkmem and amparallelvacuumoptions in IndexAmRoutine for parallel vacuum. The amusemaintenanceworkmem tells whether a particular IndexAM uses maintenance_work_mem or not. This will help in controlling the memory

pgsql: Fix compiler warning about format on Windows

2020-01-14 Thread Peter Eisentraut
Fix compiler warning about format on Windows On 64-bit Windows, pid_t is long long int, so a %d format isn't enough. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/fe233366f2e3ca44609c805ce0604c1e2122c3f9 Modified Files --

pgsql: docs: change "default role" wording to "predefined role"

2020-01-14 Thread Bruce Momjian
docs: change "default role" wording to "predefined role" The new wording was determined to be more accurate. Also, update release note links that reference these sections. Reported-by: rir...@comcast.net Discussion:

pgsql: docs: change "default role" wording to "predefined role"

2020-01-14 Thread Bruce Momjian
docs: change "default role" wording to "predefined role" The new wording was determined to be more accurate. Also, update release note links that reference these sections. Reported-by: rir...@comcast.net Discussion:

pgsql: docs: change "default role" wording to "predefined role"

2020-01-14 Thread Bruce Momjian
docs: change "default role" wording to "predefined role" The new wording was determined to be more accurate. Also, update release note links that reference these sections. Reported-by: rir...@comcast.net Discussion:

pgsql: docs: change "default role" wording to "predefined role"

2020-01-14 Thread Bruce Momjian
docs: change "default role" wording to "predefined role" The new wording was determined to be more accurate. Also, update release note links that reference these sections. Reported-by: rir...@comcast.net Discussion:

Re: pgsql: Update copyrights for 2020

2020-01-14 Thread Bruce Momjian
On Mon, Jan 6, 2020 at 07:15:23PM -0300, Alvaro Herrera wrote: > On 2020-Jan-07, Thomas Munro wrote: > > > On Fri, Jan 3, 2020 at 7:41 AM Alvaro Herrera > > wrote: > > > On 2020-Jan-01, Bruce Momjian wrote: > > > > Update copyrights for 2020 > > > > src/test/ssl/ssl/client-der.key

pgsql: Revert copyright script changes to binary *.key files

2020-01-14 Thread Bruce Momjian
Revert copyright script changes to binary *.key files This reverts part of commit 7559d8ebfa. The copyright script has already been updated to skip *.key files. Reported-by: Alvaro Herrera Discussion: https://postgr.es/m/20200102184059.GA25435@alvherre.pgsql Backpatch-through: master Branch

pgsql: tools/copyright.pl: skip copyright changes for *.key files

2020-01-14 Thread Bruce Momjian
tools/copyright.pl: skip copyright changes for *.key files Reported-by: Alvaro Herrera Discussion: https://postgr.es/m/20200102184059.GA25435@alvherre.pgsql Backpatch-through: master Branch -- master Details ---

pgsql: Expose PQbackendPID() through walreceiver API

2020-01-14 Thread Peter Eisentraut
Expose PQbackendPID() through walreceiver API This will be used by a subsequent patch. Reviewed-by: Masahiko Sawada Discussion: https://www.postgresql.org/message-id/CA%2Bfd4k4dM0iEPLxyVyme2RAFsn8SUgrNtBJOu81YqTY4V%2BnqZA%40mail.gmail.com Branch -- master Details ---

pgsql: walreceiver uses a temporary replication slot by default

2020-01-14 Thread Peter Eisentraut
walreceiver uses a temporary replication slot by default If no permanent replication slot is configured using primary_slot_name, the walreceiver now creates and uses a temporary replication slot. A new setting wal_receiver_create_temp_slot can be used to disable this behavior, for example, if

pgsql: ALTER TABLE ... ALTER COLUMN ... DROP EXPRESSION

2020-01-14 Thread Peter Eisentraut
ALTER TABLE ... ALTER COLUMN ... DROP EXPRESSION Add an ALTER TABLE subcommand for dropping the generated property from a column, per SQL standard. Reviewed-by: Sergei Kornilov Discussion: https://www.postgresql.org/message-id/flat/2f7f1d9c-946e-0453-d841-4f38eb9d69b6%402ndquadrant.com Branch

pgsql: Make rewriter prevent auto-updates on views with conditional INS

2020-01-14 Thread Dean Rasheed
Make rewriter prevent auto-updates on views with conditional INSTEAD rules. A view with conditional INSTEAD rules and no unconditional INSTEAD rules or INSTEAD OF triggers is not auto-updatable. Previously we relied on a check in the executor to catch this, but that's problematic since the

pgsql: Make rewriter prevent auto-updates on views with conditional INS

2020-01-14 Thread Dean Rasheed
Make rewriter prevent auto-updates on views with conditional INSTEAD rules. A view with conditional INSTEAD rules and no unconditional INSTEAD rules or INSTEAD OF triggers is not auto-updatable. Previously we relied on a check in the executor to catch this, but that's problematic since the

pgsql: Make rewriter prevent auto-updates on views with conditional INS

2020-01-14 Thread Dean Rasheed
Make rewriter prevent auto-updates on views with conditional INSTEAD rules. A view with conditional INSTEAD rules and no unconditional INSTEAD rules or INSTEAD OF triggers is not auto-updatable. Previously we relied on a check in the executor to catch this, but that's problematic since the

pgsql: Make rewriter prevent auto-updates on views with conditional INS

2020-01-14 Thread Dean Rasheed
Make rewriter prevent auto-updates on views with conditional INSTEAD rules. A view with conditional INSTEAD rules and no unconditional INSTEAD rules or INSTEAD OF triggers is not auto-updatable. Previously we relied on a check in the executor to catch this, but that's problematic since the

pgsql: Make rewriter prevent auto-updates on views with conditional INS

2020-01-14 Thread Dean Rasheed
Make rewriter prevent auto-updates on views with conditional INSTEAD rules. A view with conditional INSTEAD rules and no unconditional INSTEAD rules or INSTEAD OF triggers is not auto-updatable. Previously we relied on a check in the executor to catch this, but that's problematic since the

pgsql: Make rewriter prevent auto-updates on views with conditional INS

2020-01-14 Thread Dean Rasheed
Make rewriter prevent auto-updates on views with conditional INSTEAD rules. A view with conditional INSTEAD rules and no unconditional INSTEAD rules or INSTEAD OF triggers is not auto-updatable. Previously we relied on a check in the executor to catch this, but that's problematic since the

pgsql: Make rewriter prevent auto-updates on views with conditional INS

2020-01-14 Thread Dean Rasheed
Make rewriter prevent auto-updates on views with conditional INSTEAD rules. A view with conditional INSTEAD rules and no unconditional INSTEAD rules or INSTEAD OF triggers is not auto-updatable. Previously we relied on a check in the executor to catch this, but that's problematic since the