Re: Logical Replication Custom Column Expression
| От | Stavros Koureas |
|---|---|
| Тема | Re: Logical Replication Custom Column Expression |
| Дата | |
| Msg-id | CA+O1jk4qsW5yOXCjgut7sT6SZn-frbobbakUSSp7i1iKa5a1FQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Logical Replication Custom Column Expression (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>) |
| Ответы |
Re: Logical Replication Custom Column Expression
Re: Logical Replication Custom Column Expression |
| Список | pgsql-hackers |
Στις Τρί 29 Νοε 2022 στις 3:27 μ.μ., ο/η Ashutosh Bapat <ashutosh.bapat.oss@gmail.com> έγραψε:
> That would be too restrictive - not necessarily in your application
> but generally. There could be some tables where consolidating rows> with same PK from different publishers into a single row in subscriber
> would be desirable. I think we need to enable the property for every
> subscriber that intends to add publisher column to the desired and
> subscribed tables. But there should be another option per table which
> will indicate that receiver should add publisher when INSERTING row to
> that table.
In that case I am not sure how this will be implemented as currently postgres subscribers can have multiple tables streamed from a single publisher.
In that case we may have an additional syntax on subscriber, for example:
CREATE SUBSCRIPTION sub1 CONNECTION 'host=localhost port=5432 user=postgres password=XXXXXX dbname=publisher1' PUBLICATION pub1 with (enabled = false, create_slot = false, slot_name = NONE, tables = {tableA:union, tableB:none, ....});
Something like this?
> And yes, probably you need to change the way you reply to email on
> this list. Top-posting is generally avoided. See
> https://wiki.postgresql.org/wiki/Mailing_Lists.
Thanks for bringing this into the discussion :)
В списке pgsql-hackers по дате отправления: