RE: [Patch] Use *other* indexes on the subscriber when REPLICA IDENTITY is FULL

Hayato Kuroda (Fujitsu) <kuroda.hayato@fujitsu.com>

From: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
To: 'Önder Kalacı' <onderkalaci@gmail.com>
Cc: Postgres hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-06-27T01:09:42Z
Lists: pgsql-hackers

Attachments

> Please see attched script to reproduce that. The final DELETE statement cannot
> be
> replicated at the subscriber on my env.

Sorry, I forgot to attach...

Best Regards,
Hayato Kuroda
FUJITSU LIMITED

Commits

  1. Allow the use of a hash index on the subscriber during replication.

  2. Allow the use of indexes other than PK and REPLICA IDENTITY on the subscriber.