RE: Added schema level support for publication.

From: "tanghy(dot)fnst(at)fujitsu(dot)com" <tanghy(dot)fnst(at)fujitsu(dot)com>
To: vignesh C <vignesh21(at)gmail(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Greg Nancarrow <gregn4422(at)gmail(dot)com>, Ajin Cherian <itsajin(at)gmail(dot)com>, "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, Rahila Syed <rahilasyed90(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
Subject: RE: Added schema level support for publication.
Date: 2021-09-06 04:23:03
Message-ID: OS0PR01MB611367CFB590FCD035BA4D54FBD29@OS0PR01MB6113.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thursday, September 2, 2021 2:36 PM vignesh C <vignesh21(at)gmail(dot)com> wrote:
>
> On Wed, Sep 1, 2021 at 11:14 AM tanghy(dot)fnst(at)fujitsu(dot)com
> <tanghy(dot)fnst(at)fujitsu(dot)com> wrote:
> >
> > 3. When using '\dn+', I noticed that the list of publications only contains the
> > publications for "SCHEMA", "FOR ALL TABLES" publications are not shown. Is it
> designed on purpose?
> > (The result of '\d+' lists the publications of "SCHEAME" and "FOR ALL TABLES").
> >
> > For example:
> > create schema sch1;
> > create table sch1.tbl(a int);
> > create publication pub_schema for all tables in schema sch1;
> > create publication pub_all_tables for all tables;
>
> I'm not sure if it is intentional or not, Do you want to post the
> question in a separate thread and see if that should be handled?
>

Sorry, maybe I didn't make my last question clearly enough.

In HEAD(where schema level is not supported for publication), there is no publication
information in the result of '\dn+'.

With this schema patch, '\dn+' shows the publications related to the schema, but ALL
TABLES publications are not shown. Do you think we should add ALL TABLES publications, too?

Regards
Tang

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message tanghy.fnst@fujitsu.com 2021-09-06 04:31:42 RE: [PATCH] Add tab-complete for backslash commands
Previous Message Michael Paquier 2021-09-06 04:22:30 Re: pg_receivewal starting position