pgsql: Tag refs/tags/REL_14_4 was created

2022-06-15 Thread noreply
Tag refs/tags/REL_14_4 was created.


pgsql: Link to MVCC docs in MERGE docs

2022-06-15 Thread Alvaro Herrera
Link to MVCC docs in MERGE docs

In addition, this moves the new paragraph in the MVCC page upwards, for
a more consistent flow; some minor markup mistakes, style issues and
typos are fixed too.

Per comments from Justin Pryzby.

Discussion: https://postgr.es/m/20220511163350.gl19...@telsasoft.com

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/eebf244770a9450d9fe2597abde725a9b984

Modified Files
--
doc/src/sgml/mvcc.sgml  | 71 +++--
doc/src/sgml/ref/merge.sgml |  4 +++
2 files changed, 40 insertions(+), 35 deletions(-)



Re: pgsql: Re-add locally-generated files in pg_upgrade's .gitignore and Ma

2022-06-15 Thread Tom Lane
Michael Paquier  writes:
> Re-add locally-generated files in pg_upgrade's .gitignore and Makefile

Thanks.

regards, tom lane




pgsql: Fix data inconsistency between publisher and subscriber.

2022-06-15 Thread Amit Kapila
Fix data inconsistency between publisher and subscriber.

We were not updating the partition map cache in the subscriber even when
the corresponding remote rel is changed. Due to this data was getting
incorrectly replicated for partition tables after the publisher has
changed the table schema.

Fix it by resetting the required entries in the partition map cache after
receiving a new relation mapping from the publisher.

Reported-by: Shi Yu
Author: Shi Yu, Hou Zhijie
Reviewed-by: Amit Langote, Amit Kapila
Backpatch-through: 13, where it was introduced
Discussion: 
https://postgr.es/m/oszpr01mb6310f46cd425a967e4aef736fd...@oszpr01mb6310.jpnprd01.prod.outlook.com

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/b7658c24c7c1ffad131a7fdf67ce7fc008be1177

Modified Files
--
src/backend/replication/logical/relation.c | 34 ++
src/backend/replication/logical/worker.c   |  3 +++
src/include/replication/logicalrelation.h  |  1 +
src/test/subscription/t/013_partition.pl   | 15 +
4 files changed, 53 insertions(+)



pgsql: Fix data inconsistency between publisher and subscriber.

2022-06-15 Thread Amit Kapila
Fix data inconsistency between publisher and subscriber.

We were not updating the partition map cache in the subscriber even when
the corresponding remote rel is changed. Due to this data was getting
incorrectly replicated for partition tables after the publisher has
changed the table schema.

Fix it by resetting the required entries in the partition map cache after
receiving a new relation mapping from the publisher.

Reported-by: Shi Yu
Author: Shi Yu, Hou Zhijie
Reviewed-by: Amit Langote, Amit Kapila
Backpatch-through: 13, where it was introduced
Discussion: 
https://postgr.es/m/oszpr01mb6310f46cd425a967e4aef736fd...@oszpr01mb6310.jpnprd01.prod.outlook.com

Branch
--
REL_13_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/1f9a7738eb84f341a9b39689f33c887d1ef39487

Modified Files
--
src/backend/replication/logical/relation.c | 34 ++
src/backend/replication/logical/worker.c   |  3 +++
src/include/replication/logicalrelation.h  |  1 +
src/test/subscription/t/013_partition.pl   | 17 ++-
4 files changed, 54 insertions(+), 1 deletion(-)



pgsql: Fix data inconsistency between publisher and subscriber.

2022-06-15 Thread Amit Kapila
Fix data inconsistency between publisher and subscriber.

We were not updating the partition map cache in the subscriber even when
the corresponding remote rel is changed. Due to this data was getting
incorrectly replicated for partition tables after the publisher has
changed the table schema.

Fix it by resetting the required entries in the partition map cache after
receiving a new relation mapping from the publisher.

Reported-by: Shi Yu
Author: Shi Yu, Hou Zhijie
Reviewed-by: Amit Langote, Amit Kapila
Backpatch-through: 13, where it was introduced
Discussion: 
https://postgr.es/m/oszpr01mb6310f46cd425a967e4aef736fd...@oszpr01mb6310.jpnprd01.prod.outlook.com

Branch
--
REL_14_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/0980adfd4d021e3329bf41452ce1a1210321974f

Modified Files
--
src/backend/replication/logical/relation.c | 34 ++
src/backend/replication/logical/worker.c   |  3 +++
src/include/replication/logicalrelation.h  |  1 +
src/test/subscription/t/013_partition.pl   | 17 ++-
4 files changed, 54 insertions(+), 1 deletion(-)