[COMMITTERS] pgsql: Clear auth context correctly when re-connecting after failed aut

2017-06-07 Thread Heikki Linnakangas
Clear auth context correctly when re-connecting after failed auth attempt. If authentication over an SSL connection fails, with sslmode=prefer, libpq will reconnect without SSL and retry. However, we did not clear the variables related to GSS, SSPI, and SASL authentication state, when reconnecting

[COMMITTERS] pgsql: Clear auth context correctly when re-connecting after failed aut

2017-06-07 Thread Heikki Linnakangas
Clear auth context correctly when re-connecting after failed auth attempt. If authentication over an SSL connection fails, with sslmode=prefer, libpq will reconnect without SSL and retry. However, we did not clear the variables related to GSS, SSPI, and SASL authentication state, when reconnecting

[COMMITTERS] pgsql: Clear auth context correctly when re-connecting after failed aut

2017-06-07 Thread Heikki Linnakangas
Clear auth context correctly when re-connecting after failed auth attempt. If authentication over an SSL connection fails, with sslmode=prefer, libpq will reconnect without SSL and retry. However, we did not clear the variables related to GSS, SSPI, and SASL authentication state, when reconnecting

[COMMITTERS] pgsql: Clear auth context correctly when re-connecting after failed aut

2017-06-07 Thread Heikki Linnakangas
Clear auth context correctly when re-connecting after failed auth attempt. If authentication over an SSL connection fails, with sslmode=prefer, libpq will reconnect without SSL and retry. However, we did not clear the variables related to GSS, SSPI, and SASL authentication state, when reconnecting

[COMMITTERS] pgsql: Clear auth context correctly when re-connecting after failed aut

2017-06-07 Thread Heikki Linnakangas
Clear auth context correctly when re-connecting after failed auth attempt. If authentication over an SSL connection fails, with sslmode=prefer, libpq will reconnect without SSL and retry. However, we did not clear the variables related to GSS, SSPI, and SASL authentication state, when reconnecting

[COMMITTERS] pgsql: Fix docs to not claim ECPG's SET CONNECTION is not thread-aware.

2017-06-07 Thread Michael Meskes
Fix docs to not claim ECPG's SET CONNECTION is not thread-aware. Changed by: Tsunakawa, Takayuki Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/7d46a672a59e53a029f05b6e2df8cdc899658293 Modified Files -- doc/src/sgml/ecpg.sgml | 5 ++--- 1 file c

[COMMITTERS] pgsql: Fix docs to not claim ECPG's SET CONNECTION is not thread-aware.

2017-06-07 Thread Michael Meskes
Fix docs to not claim ECPG's SET CONNECTION is not thread-aware. Changed by: Tsunakawa, Takayuki Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/06200b858edc7b61228d281d84201d4978d841cd Modified Files -- doc/src/sgml/ecpg.sgml | 5 ++--- 1 file c

[COMMITTERS] pgsql: Fix docs to not claim ECPG's SET CONNECTION is not thread-aware.

2017-06-07 Thread Michael Meskes
Fix docs to not claim ECPG's SET CONNECTION is not thread-aware. Changed by: Tsunakawa, Takayuki Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/32afb2b5628455a8de2f5169211651cfe7e4815f Modified Files -- doc/src/sgml/ecpg.sgml | 5 ++--- 1 file c

[COMMITTERS] pgsql: Fix docs to not claim ECPG's SET CONNECTION is not thread-aware.

2017-06-07 Thread Michael Meskes
Fix docs to not claim ECPG's SET CONNECTION is not thread-aware. Changed by: Tsunakawa, Takayuki Branch -- REL9_3_STABLE Details --- https://git.postgresql.org/pg/commitdiff/9d1758d1e694fbb399be054d081ec9a7520919bc Modified Files -- doc/src/sgml/ecpg.sgml | 5 ++--- 1 file c

[COMMITTERS] pgsql: Fix docs to not claim ECPG's SET CONNECTION is not thread-aware.

2017-06-07 Thread Michael Meskes
Fix docs to not claim ECPG's SET CONNECTION is not thread-aware. Changed by: Tsunakawa, Takayuki Branch -- REL9_2_STABLE Details --- https://git.postgresql.org/pg/commitdiff/ccd717a2e8a5b59f5117ce3dc6e28f71bda9a030 Modified Files -- doc/src/sgml/ecpg.sgml | 5 ++--- 1 file c

[COMMITTERS] pgsql: Prevent BEFORE triggers from violating partitioning constraints.

2017-06-07 Thread Robert Haas
Prevent BEFORE triggers from violating partitioning constraints. Since tuple-routing implicitly checks the partitioning constraints at least for the levels of the partitioning hierarchy it traverses, there's normally no need to revalidate the partitioning constraint after performing tuple routing.

[COMMITTERS] pgsql: Fix updating of pg_subscription_rel from workers

2017-06-07 Thread Peter Eisentraut
Fix updating of pg_subscription_rel from workers A logical replication worker should not insert new rows into pg_subscription_rel, only update existing rows, so that there are no races if a concurrent refresh removes rows. Adjust the API to be able to choose that behavior. Author: Masahiko Sawad

[COMMITTERS] pgsql: postgres_fdw: Allow cancellation of transaction control commands

2017-06-07 Thread Robert Haas
postgres_fdw: Allow cancellation of transaction control commands. Commit f039eaac7131ef2a4cf63a10cf98486f8bcd09d2, later back-patched with commit 1b812afb0eafe125b820cc3b95e7ca03821aa675, allowed many of the queries issued by postgres_fdw to fetch remote data to respond to cancel interrupts in a t

[COMMITTERS] pgsql: postgres_fdw: Allow cancellation of transaction control commands

2017-06-07 Thread Robert Haas
postgres_fdw: Allow cancellation of transaction control commands. Commit f039eaac7131ef2a4cf63a10cf98486f8bcd09d2, later back-patched with commit 1b812afb0eafe125b820cc3b95e7ca03821aa675, allowed many of the queries issued by postgres_fdw to fetch remote data to respond to cancel interrupts in a t

[COMMITTERS] pgsql: postgres_fdw: Allow cancellation of transaction control commands

2017-06-07 Thread Robert Haas
postgres_fdw: Allow cancellation of transaction control commands. Commit f039eaac7131ef2a4cf63a10cf98486f8bcd09d2, later back-patched with commit 1b812afb0eafe125b820cc3b95e7ca03821aa675, allowed many of the queries issued by postgres_fdw to fetch remote data to respond to cancel interrupts in a t

[COMMITTERS] pgsql: postgres_fdw: Allow cancellation of transaction control commands

2017-06-07 Thread Robert Haas
postgres_fdw: Allow cancellation of transaction control commands. Commit f039eaac7131ef2a4cf63a10cf98486f8bcd09d2, later back-patched with commit 1b812afb0eafe125b820cc3b95e7ca03821aa675, allowed many of the queries issued by postgres_fdw to fetch remote data to respond to cancel interrupts in a t

[COMMITTERS] pgsql: postgres_fdw: Allow cancellation of transaction control commands

2017-06-07 Thread Robert Haas
postgres_fdw: Allow cancellation of transaction control commands. Commit f039eaac7131ef2a4cf63a10cf98486f8bcd09d2, later back-patched with commit 1b812afb0eafe125b820cc3b95e7ca03821aa675, allowed many of the queries issued by postgres_fdw to fetch remote data to respond to cancel interrupts in a t

[COMMITTERS] pgsql: Docs: improve CREATE TABLE ref page's discussion of partition bo

2017-06-07 Thread Tom Lane
Docs: improve CREATE TABLE ref page's discussion of partition bounds. Clarify in the syntax synopsis that partition bound values must be exactly numeric literals or string literals; previously it said "bound_literal" which was defined nowhere. Replace confusing --- and, I think, incorrect in deta

[COMMITTERS] pgsql: Fix contrib/sepgsql regr tests for tup-routing constraint check

2017-06-07 Thread Joe Conway
Fix contrib/sepgsql regr tests for tup-routing constraint check change. Commit 15ce775 changed tuple-routing constraint checking logic. This affects the expected output for contrib/sepgsql, because there's no longer LOG entries reporting allowance of int4eq() execution. Per buildfarm. Branch

Re: [COMMITTERS] pgsql: Unify SIGHUP handling between normal and walsender backends.

2017-06-07 Thread Filipe Rosset
2017-06-06 20:49 GMT-03:00 Andres Freund : > On 2017-06-06 19:41:10 -0400, Tom Lane wrote: > > Andres Freund writes: > > > On 2017-06-06 02:25:18 +, Andres Freund wrote: > > >> Unify SIGHUP handling between normal and walsender backends. > > > > > This commit, or one of its siblings, seemingl