pgsql: Fix RANGE partition pruning with multiple boolean partition keys

2019-07-12 Thread David Rowley
Fix RANGE partition pruning with multiple boolean partition keys match_clause_to_partition_key incorrectly would return PARTCLAUSE_UNSUPPORTED if a bool qual could not be matched to the current partition key. This was a problem, as it causes the calling function to discard the qual and not try to

pgsql: Fix RANGE partition pruning with multiple boolean partition keys

2019-07-12 Thread David Rowley
Fix RANGE partition pruning with multiple boolean partition keys match_clause_to_partition_key incorrectly would return PARTCLAUSE_UNSUPPORTED if a bool qual could not be matched to the current partition key. This was a problem, as it causes the calling function to discard the qual and not try to

pgsql: Fix RANGE partition pruning with multiple boolean partition keys

2019-07-12 Thread David Rowley
Fix RANGE partition pruning with multiple boolean partition keys match_clause_to_partition_key incorrectly would return PARTCLAUSE_UNSUPPORTED if a bool qual could not be matched to the current partition key. This was a problem, as it causes the calling function to discard the qual and not try to

pgsql: Fix get_actual_variable_range() to cope with broken HOT chains.

2019-07-12 Thread Tom Lane
Fix get_actual_variable_range() to cope with broken HOT chains. Commit 3ca930fc3 modified get_actual_variable_range() to use a new "SnapshotNonVacuumable" snapshot type for selecting tuples that it would consider valid. However, because that snapshot type can accept recently-dead tuples, this cau

pgsql: Fix get_actual_variable_range() to cope with broken HOT chains.

2019-07-12 Thread Tom Lane
Fix get_actual_variable_range() to cope with broken HOT chains. Commit 3ca930fc3 modified get_actual_variable_range() to use a new "SnapshotNonVacuumable" snapshot type for selecting tuples that it would consider valid. However, because that snapshot type can accept recently-dead tuples, this cau

pgsql: Fix get_actual_variable_range() to cope with broken HOT chains.

2019-07-12 Thread Tom Lane
Fix get_actual_variable_range() to cope with broken HOT chains. Commit 3ca930fc3 modified get_actual_variable_range() to use a new "SnapshotNonVacuumable" snapshot type for selecting tuples that it would consider valid. However, because that snapshot type can accept recently-dead tuples, this cau

pgsql: Warn if wal_level is too low when creating a publication.

2019-07-12 Thread Thomas Munro
Warn if wal_level is too low when creating a publication. Provide a hint to users that they need to increase wal_level before subscriptions can work. Author: Lucas Viecelli, with some adjustments by Thomas Munro Reviewed-by: Tom Lane Discussion: https://postgr.es/m/CAPjy-57rn5Y9g4e5u--eSOP-7P4Qr

pgsql: Introduce timed waits for condition variables.

2019-07-12 Thread Thomas Munro
Introduce timed waits for condition variables. Provide ConditionVariableTimedSleep(), like ConditionVariableSleep() but with a timeout argument. Author: Shawn Debnath Reviewed-by: Kyotaro Horiguchi, Thomas Munro Discussion: https://postgr.es/m/[email protected]

pgsql: Forward received condition variable signals on cancel.

2019-07-12 Thread Thomas Munro
Forward received condition variable signals on cancel. After a process decides not to wait for a condition variable, it can still consume a signal before it reaches ConditionVariableCancelSleep(). In that case, pass the signal on to another waiter if possible, so that a signal doesn't go missing w

pgsql: Tab completion for CREATE TYPE.

2019-07-12 Thread Thomas Munro
Tab completion for CREATE TYPE. Author: Thomas Munro Reviewed-by: Kyotaro Horiguchi Discussion: https://postgr.es/m/CA%2BhUKGLk%3D0yLDjfviONJLzcHEzygj%3Dx6VbGH43LnXbBUvQb52g%40mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/7bdc6556fb325582b02e9a6931

pgsql: Fix tab completion for UPDATE.

2019-07-12 Thread Thomas Munro
Fix tab completion for UPDATE. Previously it suggested an extra "=" after "SET x=". Reported-by: Kyotaro Horiguchi Discussion: https://postgr.es/m/CA%2BhUKGLk%3D0yLDjfviONJLzcHEzygj%3Dx6VbGH43LnXbBUvQb52g%40mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commi

pgsql: Fix and improve several places in the docs

2019-07-12 Thread Michael Paquier
Fix and improve several places in the docs This adds some missing markups, fixes a couple of incorrect ones and clarifies some documentation in various places. Author: Liudmila Mantrova Discussion: https://postgr.es/m/[email protected] Backpatch-through: 12 Bra

pgsql: Fix and improve several places in the docs

2019-07-12 Thread Michael Paquier
Fix and improve several places in the docs This adds some missing markups, fixes a couple of incorrect ones and clarifies some documentation in various places. Author: Liudmila Mantrova Discussion: https://postgr.es/m/[email protected] Backpatch-through: 12 Bra