RE: pg_publication_tables show dropped columns

2022-09-06 Thread houzj.f...@fujitsu.com
On Wednesday, September 7, 2022 6:01 AM Tom Lane wrote: > Subject: Re: pg_publication_tables show dropped columns > > "houzj.f...@fujitsu.com" writes: > > Here is the new version patch. > > I think the query plan and cost looks better after applying the patch.

Re: pg_publication_tables show dropped columns

2022-09-06 Thread Tom Lane
"houzj.f...@fujitsu.com" writes: > Here is the new version patch. > I think the query plan and cost looks better after applying the patch. LGTM, pushed. regards, tom lane

RE: pg_publication_tables show dropped columns

2022-09-06 Thread houzj.f...@fujitsu.com
On Tuesday, September 6, 2022 11:13 AM Tom Lane wrote: > > Jaime Casanova 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. Oh, Sorry for the miss. > > This could be solv

Re: pg_publication_tables show dropped columns

2022-09-05 Thread Tom Lane
Jaime Casanova 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 a

pg_publication_tables show dropped columns

2022-09-05 Thread Jaime Casanova
Hi everyone, Just trying the new column/row filter on v15, I found this issue that could be replicated very easily. """ postgres=# create table t1(i serial primary key); CREATE TABLE postgres=# alter table t1 drop i; ALTER TABLE postgres=# alter table t1 add id serial primary key; ALTER TABLE pos