pg_publication_tables show dropped columns

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_publication_tables show dropped columns
Date: 2022-09-06 02:49:45
Message-ID: Yxa1SU4nH2HfN3/i@ahch-to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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
postgres=# create publication pub_t1 for table t1;
CREATE PUBLICATION

postgres=# select * from pg_publication_tables where pubname = 'pub_t1' \gx
-[ RECORD 1 ]---------------------------------
pubname | pub_t1
schemaname | public
tablename | t1
attnames | {........pg.dropped.1........,id}
rowfilter |
"""

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

--
Jaime Casanova
Director de Servicios Profesionales
SystemGuards - Consultores de PostgreSQL

Attachment Content-Type Size
ignore_dropped_cols_publication_tables.patch text/x-diff 702 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Junwang Zhao 2022-09-06 03:02:30 Re: Modernizing our GUC infrastructure
Previous Message Tom Lane 2022-09-06 02:48:37 Re: Modernizing our GUC infrastructure