[COMMITTERS] pgsql: Misc SCRAM code cleanups.

2017-04-28 Thread Heikki Linnakangas
Misc SCRAM code cleanups. * Move computation of SaltedPassword to a separate function from scram_ClientOrServerKey(). This saves a lot of cycles in libpq, by computing SaltedPassword only once per authentication. (Computing SaltedPassword is expensive by design.) * Split scram_ClientOrServe

[COMMITTERS] pgsql: Wait between tablesync worker restarts

2017-04-28 Thread Peter Eisentraut
Wait between tablesync worker restarts Before restarting a tablesync worker for the same relation, wait wal_retrieve_retry_interval (currently 5s by default). This avoids restarting failing workers in a tight loop. We keep the last start times in a hash table last_start_times that is separate fr

[COMMITTERS] pgsql: Fix crash when partitioned column specified twice.

2017-04-28 Thread Robert Haas
Fix crash when partitioned column specified twice. Amit Langote, reviewed by Beena Emerson Discussion: http://postgr.es/m/6ed23d3d-c09d-4cbc-3628-0a8a32f75...@lab.ntt.co.jp Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/504c2205abc7de67386f9c95630f38ee15626f07 M

[COMMITTERS] pgsql: Speed up dropping tables with many partitions.

2017-04-28 Thread Robert Haas
Speed up dropping tables with many partitions. We need to lock the parent, but we don't need a relcache entry for it. Gao Zeng Qi, reviewed by Amit Langote Discussion: http://postgr.es/m/cafmbtr0ukqjjrjehpwl5wt4rnmrjuuxggvagxpr3syyh3e+...@mail.gmail.com Branch -- master Details --- ht

[COMMITTERS] pgsql: In load_relcache_init_file, initialize rd_pdcxt.

2017-04-28 Thread Robert Haas
In load_relcache_init_file, initialize rd_pdcxt. Oversight noted by Gao Zeng Qi. Discussion: http://postgr.es/m/CAFmBtr1N3-SbepJbnGpaYp=jw-fvwmnyy7-bttrgvjvbyb8...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/5e1ccd48442dbdbe812c95cd70cc1d3c1c960

[COMMITTERS] pgsql: psql: Support identity columns in sequence display

2017-04-28 Thread Peter Eisentraut
psql: Support identity columns in sequence display Where the footer for an owned serial sequence would say "Owned by", put something analogous for a sequence belonging to an identity column. Reported-by: Vitaly Burovoy Branch -- master Details --- https://git.postgresql.org/pg/commitdi

[COMMITTERS] pgsql: Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute.

2017-04-28 Thread Robert Haas
Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute. Currently, trying to validate a NO INHERIT constraint on the parent will search for the constraint in child tables (where it is not supposed to exist), wrongly causing a "constraint does not exist" error. Amit Langote, per a report from Ha

[COMMITTERS] pgsql: Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute.

2017-04-28 Thread Robert Haas
Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute. Currently, trying to validate a NO INHERIT constraint on the parent will search for the constraint in child tables (where it is not supposed to exist), wrongly causing a "constraint does not exist" error. Amit Langote, per a report from Ha

[COMMITTERS] pgsql: Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute.

2017-04-28 Thread Robert Haas
Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute. Currently, trying to validate a NO INHERIT constraint on the parent will search for the constraint in child tables (where it is not supposed to exist), wrongly causing a "constraint does not exist" error. Amit Langote, per a report from Ha

[COMMITTERS] pgsql: Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute.

2017-04-28 Thread Robert Haas
Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute. Currently, trying to validate a NO INHERIT constraint on the parent will search for the constraint in child tables (where it is not supposed to exist), wrongly causing a "constraint does not exist" error. Amit Langote, per a report from Ha

[COMMITTERS] pgsql: Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute.

2017-04-28 Thread Robert Haas
Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute. Currently, trying to validate a NO INHERIT constraint on the parent will search for the constraint in child tables (where it is not supposed to exist), wrongly causing a "constraint does not exist" error. Amit Langote, per a report from Ha

[COMMITTERS] pgsql: Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute.

2017-04-28 Thread Robert Haas
Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute. Currently, trying to validate a NO INHERIT constraint on the parent will search for the constraint in child tables (where it is not supposed to exist), wrongly causing a "constraint does not exist" error. Amit Langote, per a report from Ha

[COMMITTERS] pgsql: doc: Fix typo in 9.6 release notes

2017-04-28 Thread Peter Eisentraut
doc: Fix typo in 9.6 release notes Author: Huong Dangminh Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/0a65b18d2d17891766627da73633e808e66ecdd1 Modified Files -- doc/src/sgml/release-9.6.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(

[COMMITTERS] pgsql: doc: Fix typo in 9.6 release notes

2017-04-28 Thread Peter Eisentraut
doc: Fix typo in 9.6 release notes Author: Huong Dangminh Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/bc920bee296ec4c1e8cd1598c71f21d80a59d351 Modified Files -- doc/src/sgml/release-9.6.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) --