Re: [HACKERS] REPLICA IDENTITY FULL

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: [HACKERS] REPLICA IDENTITY FULL
Дата
Msg-id 20170620.114613.2176020532264476348.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответ на Re: [HACKERS] REPLICA IDENTITY FULL  (Andres Freund <andres@anarazel.de>)
Ответы Re: [HACKERS] REPLICA IDENTITY FULL  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
>> Yes, that's my understanding too. However, the feature may or may not
>> work depending on the data types of columns, probably I will not
>> recommend users/my customers to use it.
> 
> I'm not sure how datatypes are playing into this?

For example, if the table consists of only INT types, REPLICA IDENTITY
FULL works with UPDATE/DELETE (i.e. replicated), but if some of them
are TEXT types, then UPDATE/DELETE does not work.

See up thread for more details.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] REPLICA IDENTITY FULL
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] REPLICA IDENTITY FULL