pgsql: Add regression tests for REPLICA IDENTITY with dropped indexes

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add regression tests for REPLICA IDENTITY with dropped indexes
Date: 2020-08-26 11:48:49
Message-ID: E1kAtv7-00031a-Rd@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add regression tests for REPLICA IDENTITY with dropped indexes

REPLICA IDENTITY USING INDEX behaves the same way as NOTHING if the
associated index is dropped, even if there is a primary key that could
be used as a fallback for the changes generated. There have never been
any tests to cover such scenarios, so this commit closes the gap.

Author: Michael Paquier
Reviewed-by: Masahiko Sawada, Rahila Syed, Euler Taveira
Discussion: https://postgr.es/m/20200522035028.GO2355@paquier.xyz

Branch
------
master

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

Modified Files
--------------
contrib/test_decoding/expected/ddl.out | 71 +++++++++++++++++++++++++++++++++-
contrib/test_decoding/sql/ddl.sql | 31 +++++++++++++++
2 files changed, 101 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2020-08-26 21:08:18 pgsql: Suppress compiler warning in non-cassert builds.
Previous Message Amit Kapila 2020-08-26 04:22:30 pgsql: Add additional information in the vacuum error context.