Re: Pgoutput not capturing the generated columns

Поиск
Список
Период
Сортировка
От Rajendra Kumar Dangwal
Тема Re: Pgoutput not capturing the generated columns
Дата
Msg-id A014A25F-5E45-4C75-9095-8E7BBF26ACDC@gmail.com
обсуждение исходный текст
Ответ на Pgoutput not capturing the generated columns  (Rajendra Kumar Dangwal <dangwalrajendra888@gmail.com>)
Ответы Re: Pgoutput not capturing the generated columns  (Rajendra Kumar Dangwal <dangwalrajendra888@gmail.com>)
Список pgsql-hackers

Thanks Euler,

Greatly appreciate your inputs.


> Should pgoutput provide a complete row? Probably. If it is an option that defaults to false and doesn't impact performance.


Yes, it would be great if this feature can be implemented.


> The logical replication design decides to compute the generated columns at subscriber side.


If I understand correctly, this approach involves establishing a function on the subscriber's side that emulates the operation executed to derive the generated column values.

If yes, I see one potential issue where disparities might surface between the values of generated columns on the subscriber's side and those computed within Postgres. This could happen if the generated column's value relies on the current_time function.

Please let me know how can we track the feature requests and the discussions around that.

Thanks,
Rajendra.

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

Предыдущее
От: "Drouvot, Bertrand"
Дата:
Сообщение: Re: WIP: new system catalog pg_wait_event
Следующее
От: Peter Smith
Дата:
Сообщение: Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication