On Tue, Sep 7, 2021 at 5:10 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > On Tue, Sep 7, 2021 at 12:45 PM vignesh C <vignes...@gmail.com> wrote: > > > > On Fri, Sep 3, 2021 at 4:49 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > > > > > > > 5. > > > If I modify the search path to remove public schema then I get the > > > below error message: > > > postgres=# Create publication mypub for all tables in schema > > > current_schema; > > > ERROR: no schema has been selected > > > > > > I think this message is not very clear. How about changing to > > > something like "current_schema doesn't contain any valid schema"? This > > > message is used in more than one place, so let's keep it the same at > > > all the places if you agree to change it. > > > > I would prefer to use the existing messages as we have used this in a > > few other places similarly. Thoughts? > > > > Yeah, I also see the same message in code but I think here usage is a > bit different. If you see a similar SQL statement that causes the same > error message then can you please give an example?
I was referring to the error message in create table postgres=# set search_path='non_existent_schema'; SET postgres=# create table t1(c1 int); ERROR: no schema has been selected to create in LINE 1: create table t1(c1 int); If it is not very useful in the case of creating a publication, then I can change it. Thoughts? Regards, Vignesh