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 |
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 |