pgsql: Allow page lock to conflict among parallel group members.

2020-03-20 Thread Amit Kapila
Allow page lock to conflict among parallel group members. This is required as it is no safer for two related processes to perform clean up in gin indexes at a time than for unrelated processes to do the same. After acquiring page locks, we can acquire relation extension lock but reverse never hap

pgsql: docs: use alias in WHERE clause of full text search example

2020-03-20 Thread Bruce Momjian
docs: use alias in WHERE clause of full text search example The current doc query specified an alias in the FROM clause and used in it the target list, but not in the WHERE clause. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected]

pgsql: docs: use alias in WHERE clause of full text search example

2020-03-20 Thread Bruce Momjian
docs: use alias in WHERE clause of full text search example The current doc query specified an alias in the FROM clause and used in it the target list, but not in the WHERE clause. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected]

pgsql: docs: use alias in WHERE clause of full text search example

2020-03-20 Thread Bruce Momjian
docs: use alias in WHERE clause of full text search example The current doc query specified an alias in the FROM clause and used in it the target list, but not in the WHERE clause. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected]

pgsql: docs: use alias in WHERE clause of full text search example

2020-03-20 Thread Bruce Momjian
docs: use alias in WHERE clause of full text search example The current doc query specified an alias in the FROM clause and used in it the target list, but not in the WHERE clause. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected]

pgsql: docs: use alias in WHERE clause of full text search example

2020-03-20 Thread Bruce Momjian
docs: use alias in WHERE clause of full text search example The current doc query specified an alias in the FROM clause and used in it the target list, but not in the WHERE clause. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected]

pgsql: docs: use alias in WHERE clause of full text search example

2020-03-20 Thread Bruce Momjian
docs: use alias in WHERE clause of full text search example The current doc query specified an alias in the FROM clause and used in it the target list, but not in the WHERE clause. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected]

pgsql: Fix bogus last-minute edit in 4e62091341b4

2020-03-20 Thread Alvaro Herrera
Fix bogus last-minute edit in 4e62091341b4 Noticed by Erik Rijkers before I was able to push the fix. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/069b750ca764a85324a138c22c3ece5cf13d684f Modified Files -- src/bin/pg_dump/pg_dump.c | 2 +- 1 file chan

Re: pgsql: pg_dump: Add FOREIGN to ALTER statements, if appropriate

2020-03-20 Thread Alvaro Herrera
On 2020-Mar-20, Erik Rijkers wrote: > pg_dump.c: In function ‘dumpTrigger’: > pg_dump.c:17469:51: error: ‘foreign’ undeclared (first use in this > function); did you mean ‘fopen’? >appendPQExpBuffer(query, "\nALTER %sTABLE %s ", foreign, >^~~

Re: pgsql: pg_dump: Add FOREIGN to ALTER statements, if appropriate

2020-03-20 Thread Erik Rijkers
On 2020-03-20 21:35, Alvaro Herrera wrote: pg_dump: Add FOREIGN to ALTER statements, if appropriate Author: Luis Carril Reviewed-by: Tomas Vondra, Daniel Gustafsson, Álvaro Herrera Discussion: https://postgr.es/m/lejpr01mb0185a19b2e7c98e5e2a031f5e7...@lejpr01mb0185.deuprd01.prod.outlook.de Bran

pgsql: pg_dump: Add FOREIGN to ALTER statements, if appropriate

2020-03-20 Thread Alvaro Herrera
pg_dump: Add FOREIGN to ALTER statements, if appropriate Author: Luis Carril Reviewed-by: Tomas Vondra, Daniel Gustafsson, Álvaro Herrera Discussion: https://postgr.es/m/lejpr01mb0185a19b2e7c98e5e2a031f5e7...@lejpr01mb0185.deuprd01.prod.outlook.de Branch -- master Details --- https://gi

pgsql: Turn off deprecated bison warnings under MSVC

2020-03-20 Thread Andrew Dunstan
Turn off deprecated bison warnings under MSVC These are disabled by the configure code, so this is just fixing an inconsistency in the MSVC code. Backpatch to all live branches. Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/80370836f7563653390065b225ece430

pgsql: Turn off deprecated bison warnings under MSVC

2020-03-20 Thread Andrew Dunstan
Turn off deprecated bison warnings under MSVC These are disabled by the configure code, so this is just fixing an inconsistency in the MSVC code. Backpatch to all live branches. Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/3163349fd7fe0115b021bfa1fbe49901

pgsql: Turn off deprecated bison warnings under MSVC

2020-03-20 Thread Andrew Dunstan
Turn off deprecated bison warnings under MSVC These are disabled by the configure code, so this is just fixing an inconsistency in the MSVC code. Backpatch to all live branches. Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/e8a6391fc1837416b7251f62485323af

pgsql: Turn off deprecated bison warnings under MSVC

2020-03-20 Thread Andrew Dunstan
Turn off deprecated bison warnings under MSVC These are disabled by the configure code, so this is just fixing an inconsistency in the MSVC code. Backpatch to all live branches. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/71c2fd0c04a5db5331879e23181bb52334e

pgsql: Turn off deprecated bison warnings under MSVC

2020-03-20 Thread Andrew Dunstan
Turn off deprecated bison warnings under MSVC These are disabled by the configure code, so this is just fixing an inconsistency in the MSVC code. Backpatch to all live branches. Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/467b408321e4d3d7a753ecd8d651bf03

pgsql: Turn off deprecated bison warnings under MSVC

2020-03-20 Thread Andrew Dunstan
Turn off deprecated bison warnings under MSVC These are disabled by the configure code, so this is just fixing an inconsistency in the MSVC code. Backpatch to all live branches. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/d0747714e6ef193c16d1acf31c15f387

pgsql: psql: Catch and report errors while printing result table

2020-03-20 Thread Peter Eisentraut
psql: Catch and report errors while printing result table Errors (for example I/O errors or disk full) while printing out result tables were completely ignored, which could result in silently truncated output in scripts, for example. Fix by adding some basic error checking and reporting. Author: