Re: Restore replication settings when modifying a field type

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

To: Quan Zongliang <quanzongliang@foxmail.com>, Euler Taveira <euler@timbira.com.br>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>

Cc: pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2020-03-05T12:45:24Z

Lists: pgsql-hackers

Attachments

v4-0001-Preserve-replica-identity-index-across-ALTER-TABL.patch (text/plain) patch v4-0001

On 2020-02-11 00:38, Quan Zongliang wrote:
> new patch attached.

I didn't like so much how the updating of the replica identity was 
hacked into the middle of ATRewriteCatalogs().  I have an alternative 
proposal in the attached patch that queues up an ALTER TABLE ... REPLICA 
IDENTITY command into the normal ALTER TABLE processing.  I have also 
added tests to the test suite.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

Preserve replica identity index across ALTER TABLE rewrite
- c15d35041206 9.5.22 landed
- 2f0dd9d93efe 9.6.18 landed
- 02530da73f04 10.13 landed
- 15cbbf81a58f 11.8 landed
- c9ef507e82eb 12.3 landed
- 1cc9c2412cc9 13.0 landed
Prevent reindex of invalid indexes on TOAST tables
- 61d7c7bce368 13.0 cited