RE: Time delayed LR (WAS Re: logical replication restrictions)
От | Hayato Kuroda (Fujitsu) |
---|---|
Тема | RE: Time delayed LR (WAS Re: logical replication restrictions) |
Дата | |
Msg-id | TYAPR01MB5866EC1CC5F194FE9DEC90B5F51C9@TYAPR01MB5866.jpnprd01.prod.outlook.com обсуждение исходный текст |
Ответ на | Re: Time delayed LR (WAS Re: logical replication restrictions) (Andres Freund <andres@anarazel.de>) |
Ответы |
RE: Time delayed LR (WAS Re: logical replication restrictions)
|
Список | pgsql-hackers |
Dear Andres, Thanks for reporting! I have analyzed the problem and found the root cause. This feature seemed not to work on 32-bit OSes. This was because the calculation of delay_time was wrong. The first argument of this should be TimestampTz datatype, not Datum: ``` + /* Set apply delay */ + delay_until = TimestampTzPlusMilliseconds(TimestampTzGetDatum(ts), + MySubscription->applydelay); ``` In more detail, the datum representation of int64 contains the value itself on 64-bit OSes, but it contains the pointer to the value on 32-bit. After modifying the issue, this will work on 32-bit environments. Best Regards, Hayato Kuroda FUJITSU LIMITED
В списке pgsql-hackers по дате отправления: