| 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: | Whole Thread | Raw Message | 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 |