logical replication: \dRp+ and "for all tables"

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: logical replication: \dRp+ and "for all tables"
Date: 2017-06-09 22:29:15
Message-ID: CAMkU=1yXxu7=ApzqfFOOK4OUr+BPt3E8n2C--b3p-JmqmmWTyQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

If I create a publication "for all tables", \dRp+ doesn't indicate it is
for all tables, it just gives a list of the tables.

So it doesn't distinguish between a publication specified to be for all
tables (which will be dynamic regarding future additions), and one which
just happens to include all the table which currently exist.

That seems unfortunate. Should the "for all tables" be included as another
column in \dRp and \dRp+, or at least as a footnote tag in \dRp+ ?

Cheers,

Jeff

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2017-06-09 23:17:20 Re: logical replication NOTICE "synchronized table states"
Previous Message Joe Conway 2017-06-09 21:52:17 Re: [BUGS] BUG #14682: row level security not work with partitioned table