Re: pg_publication_tables show dropped columns

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_publication_tables show dropped columns
Дата
Msg-id 3025892.1662433982@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_publication_tables show dropped columns  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Ответы RE: pg_publication_tables show dropped columns  ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>)
Список pgsql-hackers
Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> Just trying the new column/row filter on v15, I found this issue that
> could be replicated very easily.

Bleah.  Post-beta4 catversion bump, here we come.

> This could be solved by adding a "NOT attisdropped", simple patch
> attached.

That view seems quite inefficient as written --- I wonder if we
can't do better by nuking the join-to-unnest business and putting
the restriction in a WHERE clause on the pg_attribute scan.
The query plan that you get for it right now is certainly awful.

            regards, tom lane



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

Предыдущее
От: Junwang Zhao
Дата:
Сообщение: Re: Modernizing our GUC infrastructure
Следующее
От: vignesh C
Дата:
Сообщение: Re: Handle infinite recursion in logical replication setup