Re: Support logical replication of DDLs

Поиск
Список
Период
Сортировка
От li jie
Тема Re: Support logical replication of DDLs
Дата
Msg-id CAGfChW4vxVCgWs2=b+SDag0j3G-3Aqw5XvKnHVAReB-iysyj+g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Support logical replication of DDLs  (Zheng Li <zhengli10@gmail.com>)
Ответы Re: Support logical replication of DDLs  (Zheng Li <zhengli10@gmail.com>)
Список pgsql-hackers
I noticed that the issue of ownership seems to have not been considered.
For example, if a user 'a' from the publishing side creates a table t1,
the owner of t1 is not user 'a' after it is replicated to the subscribing side.
This is a situation that has not been encountered in previous DML replication.

I think the ownership relationship should not be lost,
and we should perhaps add it back,
like pg_dump "ALTER TABLE public.t1 OWNER TO a;",
even though we do not currently support the replication of USER.


Thought?  li jie.



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

Предыдущее
От: "Takamichi Osumi (Fujitsu)"
Дата:
Сообщение: RE: Time delayed LR (WAS Re: logical replication restrictions)
Следующее
От: Peter Smith
Дата:
Сообщение: Re: Force streaming every change in logical decoding