pgsql: Make "kerberos" test suite independent of "localhost" name resol

2018-08-03 Thread Noah Misch
Make "kerberos" test suite independent of "localhost" name resolution. This suite malfunctioned if the canonical name of "localhost" was something other than "localhost", such as "localhost.localdomain". Use hostaddr=127.0.0.1 and a fictitious host=, so the resolver's answers for "localhost"

pgsql: Make "kerberos" test suite independent of "localhost" name resol

2018-08-03 Thread Noah Misch
Make "kerberos" test suite independent of "localhost" name resolution. This suite malfunctioned if the canonical name of "localhost" was something other than "localhost", such as "localhost.localdomain". Use hostaddr=127.0.0.1 and a fictitious host=, so the resolver's answers for "localhost"

pgsql: Add table relcache invalidation to index builds.

2018-08-03 Thread Peter Geoghegan
Add table relcache invalidation to index builds. It's necessary to make sure that owning tables have a relcache invalidation prior to advancing the command counter to make newly-entered catalog tuples for the index visible. inval.c must be able to maintain the consistency of the local caches in

pgsql: Add table relcache invalidation to index builds.

2018-08-03 Thread Peter Geoghegan
Add table relcache invalidation to index builds. It's necessary to make sure that owning tables have a relcache invalidation prior to advancing the command counter to make newly-entered catalog tuples for the index visible. inval.c must be able to maintain the consistency of the local caches in

pgsql: Add table relcache invalidation to index builds.

2018-08-03 Thread Peter Geoghegan
Add table relcache invalidation to index builds. It's necessary to make sure that owning tables have a relcache invalidation prior to advancing the command counter to make newly-entered catalog tuples for the index visible. inval.c must be able to maintain the consistency of the local caches in

pgsql: Add table relcache invalidation to index builds.

2018-08-03 Thread Peter Geoghegan
Add table relcache invalidation to index builds. It's necessary to make sure that owning tables have a relcache invalidation prior to advancing the command counter to make newly-entered catalog tuples for the index visible. inval.c must be able to maintain the consistency of the local caches in

pgsql: Add table relcache invalidation to index builds.

2018-08-03 Thread Peter Geoghegan
Add table relcache invalidation to index builds. It's necessary to make sure that owning tables have a relcache invalidation prior to advancing the command counter to make newly-entered catalog tuples for the index visible. inval.c must be able to maintain the consistency of the local caches in

pgsql: Add table relcache invalidation to index builds.

2018-08-03 Thread Peter Geoghegan
Add table relcache invalidation to index builds. It's necessary to make sure that owning tables have a relcache invalidation prior to advancing the command counter to make newly-entered catalog tuples for the index visible. inval.c must be able to maintain the consistency of the local caches in

pgsql: Add table relcache invalidation to index builds.

2018-08-03 Thread Peter Geoghegan
Add table relcache invalidation to index builds. It's necessary to make sure that owning tables have a relcache invalidation prior to advancing the command counter to make newly-entered catalog tuples for the index visible. inval.c must be able to maintain the consistency of the local caches in

pgsql: First-draft release notes for 10.5.

2018-08-03 Thread Tom Lane
First-draft release notes for 10.5. As usual, the release notes for other branches will be made by cutting these down, but put them up for community review first. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c1455de2af2eb06ee493f9982f060ac7e571f656 Modified

pgsql: Add 'n' to list of possible values to pg_default_acl.defaclobjty

2018-08-03 Thread Alvaro Herrera
Add 'n' to list of possible values to pg_default_acl.defaclobjtype This was missed in commit ab89e465cb20; backpatch to v10. Author: Fabien Coelho Discussion: https://postgr.es/m/alpine.DEB.2.21.1807302243001.13230@lancre Branch -- REL_10_STABLE Details ---

pgsql: Add 'n' to list of possible values to pg_default_acl.defaclobjty

2018-08-03 Thread Alvaro Herrera
Add 'n' to list of possible values to pg_default_acl.defaclobjtype This was missed in commit ab89e465cb20; backpatch to v10. Author: Fabien Coelho Discussion: https://postgr.es/m/alpine.DEB.2.21.1807302243001.13230@lancre Branch -- REL_11_STABLE Details ---

pgsql: Fix pg_replication_slot example output

2018-08-03 Thread Alvaro Herrera
Fix pg_replication_slot example output The example output of pg_replication_slot is wrong. Correct it and make the output stable by explicitly listing columns to output. Author: Kyotaro Horiguchi Reviewed-by: Michael Paquier Discussion:

pgsql: Fix pg_replication_slot example output

2018-08-03 Thread Alvaro Herrera
Fix pg_replication_slot example output The example output of pg_replication_slot is wrong. Correct it and make the output stable by explicitly listing columns to output. Author: Kyotaro Horiguchi Reviewed-by: Michael Paquier Discussion:

pgsql: Fix pg_replication_slot example output

2018-08-03 Thread Alvaro Herrera
Fix pg_replication_slot example output The example output of pg_replication_slot is wrong. Correct it and make the output stable by explicitly listing columns to output. Author: Kyotaro Horiguchi Reviewed-by: Michael Paquier Discussion:

pgsql: Fix pg_replication_slot example output

2018-08-03 Thread Alvaro Herrera
Fix pg_replication_slot example output The example output of pg_replication_slot is wrong. Correct it and make the output stable by explicitly listing columns to output. Author: Kyotaro Horiguchi Reviewed-by: Michael Paquier Discussion:

pgsql: Fix pg_replication_slot example output

2018-08-03 Thread Alvaro Herrera
Fix pg_replication_slot example output The example output of pg_replication_slot is wrong. Correct it and make the output stable by explicitly listing columns to output. Author: Kyotaro Horiguchi Reviewed-by: Michael Paquier Discussion:

Re: pgsql: Address set of issues with errno handling

2018-08-03 Thread Tom Lane
Michael Paquier writes: > Address set of issues with errno handling I happened to look at this patch while working up the release notes, and I don't think it's right at all for this aspect: > 1) For write() calls, sometimes the system may return less bytes than > what has been written without

pgsql: Change libpq's internal uses of PQhost() to inspect host field d

2018-08-03 Thread Tom Lane
Change libpq's internal uses of PQhost() to inspect host field directly. Commit 1944cdc98 changed PQhost() to return the hostaddr value when that is specified and host isn't. This is a good idea in general, but fe-auth.c and related files contain PQhost() calls for which it isn't. Specifically,

pgsql: Remove no-longer-appropriate special case in psql's \conninfo co

2018-08-03 Thread Tom Lane
Remove no-longer-appropriate special case in psql's \conninfo code. \conninfo prints the results of PQhost() and some other libpq functions. It used to override the PQhost() result with the hostaddr parameter if that'd been given, but that's unhelpful when multiple hosts were listed in the

pgsql: Remove no-longer-appropriate special case in psql's \conninfo co

2018-08-03 Thread Tom Lane
Remove no-longer-appropriate special case in psql's \conninfo code. \conninfo prints the results of PQhost() and some other libpq functions. It used to override the PQhost() result with the hostaddr parameter if that'd been given, but that's unhelpful when multiple hosts were listed in the

pgsql: Change libpq's internal uses of PQhost() to inspect host field d

2018-08-03 Thread Tom Lane
Change libpq's internal uses of PQhost() to inspect host field directly. Commit 1944cdc98 changed PQhost() to return the hostaddr value when that is specified and host isn't. This is a good idea in general, but fe-auth.c and related files contain PQhost() calls for which it isn't. Specifically,

pgsql: Remove no-longer-appropriate special case in psql's \conninfo co

2018-08-03 Thread Tom Lane
Remove no-longer-appropriate special case in psql's \conninfo code. \conninfo prints the results of PQhost() and some other libpq functions. It used to override the PQhost() result with the hostaddr parameter if that'd been given, but that's unhelpful when multiple hosts were listed in the

pgsql: Change libpq's internal uses of PQhost() to inspect host field d

2018-08-03 Thread Tom Lane
Change libpq's internal uses of PQhost() to inspect host field directly. Commit 1944cdc98 changed PQhost() to return the hostaddr value when that is specified and host isn't. This is a good idea in general, but fe-auth.c and related files contain PQhost() calls for which it isn't. Specifically,

pgsql: libpq: PQhost to return active connected host or hostaddr

2018-08-03 Thread Tom Lane
libpq: PQhost to return active connected host or hostaddr Previously, PQhost didn't return the connected host details when the connection type was CHT_HOST_ADDRESS (i.e., via hostaddr). Instead, it returned the complete host connection parameter (which could contain multiple hosts) or the

pgsql: Fix buffer usage stats for parallel nodes.

2018-08-03 Thread Amit Kapila
Fix buffer usage stats for parallel nodes. The buffer usage stats is accounted only for the execution phase of the node. For Gather and Gather Merge nodes, such stats are accumulated at the time of shutdown of workers which is done after execution of node due to which we missed to account them

pgsql: Fix buffer usage stats for parallel nodes.

2018-08-03 Thread Amit Kapila
Fix buffer usage stats for parallel nodes. The buffer usage stats is accounted only for the execution phase of the node. For Gather and Gather Merge nodes, such stats are accumulated at the time of shutdown of workers which is done after execution of node due to which we missed to account them

pgsql: Fix buffer usage stats for parallel nodes.

2018-08-03 Thread Amit Kapila
Fix buffer usage stats for parallel nodes. The buffer usage stats is accounted only for the execution phase of the node. For Gather and Gather Merge nodes, such stats are accumulated at the time of shutdown of workers which is done after execution of node due to which we missed to account them

pgsql: Fix buffer usage stats for parallel nodes.

2018-08-03 Thread Amit Kapila
Fix buffer usage stats for parallel nodes. The buffer usage stats is accounted only for the execution phase of the node. For Gather and Gather Merge nodes, such stats are accumulated at the time of shutdown of workers which is done after execution of node due to which we missed to account them