Horton

Add regression tests for REPLICA IDENTITY with dropped indexes

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: fe7fd4e9613f58262d30782a34b01cc0c4cbbeb5
Author: Michael Paquier <michael@paquier.xyz>
Date: 2020-08-26T11:42:27Z
Releases: 14.0 
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

Files

PathChange+/−
contrib/test_decoding/expected/ddl.out modified +70 −1
contrib/test_decoding/sql/ddl.sql modified +31 −0

Discussion