From: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> |
---|---|
To: | vignesh C <vignesh21(at)gmail(dot)com> |
Cc: | tanghy(dot)fnst(at)fujitsu(dot)com, Rahila Syed <rahilasyed90(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Added schema level support for publication. |
Date: | 2021-06-11 13:13:44 |
Message-ID: | CALj2ACUcN+_6B1oZUMyxB7HOryfkeeH4F6+UqPkmpZN49C2xnQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, Jun 11, 2021, 6:22 PM Bharath Rupireddy <
bharath(dot)rupireddyforpostgres(at)gmail(dot)com> wrote:
> On Sat, Jun 5, 2021 at 7:02 PM vignesh C <vignesh21(at)gmail(dot)com> wrote:
> > Thanks for identifying and reporting this issue. I have \dn with the
> > equivalent query to display only the publication name. The updated
> > patch has the fix for the same.
>
> Currently, FOR ALL TABLES is there to add all the tables(existing and
> future) in the current database in which the publication is created. I
> wonder before providing FOR SCHEMA capability, we better target FOR
> DATABASE first, something like CREATE PUBLICATION ... FOR DATABASE
> foo, bar, baz, qux; Of course users with the proper permissions on the
> specified databases can add them to the publication. This can help to
> add all the tables in other databases as well. Then, the CREATE
> PUBLICATION ... FOR SCHEMA foo, bar, baz, qux; makes more sense.
> Because, my understanding is that: database is a collection of tables,
> schema is a collection of databases. I may be wrong here, but it's
> just a thought. What do you think?
>
Please ignore above comment. I was confused about what a database and
schema is in postgres. I'm sorry for the noise.
https://www.postgresql.org/docs/devel/ddl-schemas.html
Regards,
Bharath Rupireddy.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-06-11 13:38:25 | Re: Add PortalDrop in exec_execute_message |
Previous Message | Bharath Rupireddy | 2021-06-11 12:52:29 | Re: Added schema level support for publication. |