Re: Restore replication settings when modifying a field type

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Restore replication settings when modifying a field type
Дата
Msg-id 61d38b0e-0831-d206-8390-2a08bb51905d@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Restore replication settings when modifying a field type  (Euler Taveira <euler@timbira.com.br>)
Ответы Re: Restore replication settings when modifying a field type
Re: Restore replication settings when modifying a field type
Список pgsql-hackers
On 2019-11-01 04:39, Euler Taveira wrote:
> ATExecAlterColumnType records everything that depends on the column
> and for indexes it saves the definition (via pg_get_indexdef_string).
> Definition is not sufficient for reconstructing the replica identity
> information because there is not such keyword for replica identity in
> CREATE INDEX. The new index should call relation_mark_replica_identity
> to fix pg_index.indisreplident.

Yeah, I don't think we need to do the full dance of reverse compiling 
the SQL command and reexecuting it, as the patch currently does.  That's 
only necessary for rebuilding the index itself.  For re-setting the 
replica identity, we can just use the internal API as you say.

Also, a few test cases would be nice for this patch.

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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Greatest Common Divisor
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: PATCH: logical_work_mem and logical streaming of largein-progress transactions