Add regression tests for REPLICA IDENTITY with dropped indexes
authorMichael Paquier <michael@paquier.xyz>
Wed, 26 Aug 2020 11:42:27 +0000 (20:42 +0900)
committerMichael Paquier <michael@paquier.xyz>
Wed, 26 Aug 2020 11:42:27 +0000 (20:42 +0900)
commitfe7fd4e9613f58262d30782a34b01cc0c4cbbeb5
treec33efe07b6764614a5ca7d2e2148905e6e21c3c3
parent7e453634bb62f06a048f5562ba59d52aa1f28d12
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
contrib/test_decoding/expected/ddl.out
contrib/test_decoding/sql/ddl.sql