[pgpool-hackers: 1544] Re: Syntax for pgpool SHOW and SET commands

[Muhammad Usama]

On Fri, May 6, 2016 at 4:44 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> Usama,
>
> Why do we need "PGPOOL" keyword? It seems to be annoying.
>

Basically, there are two reasons. First,is there are some configuration
parameter names that are same in PostgreSQL and pgpool-II like
"port", "log_min_messages"  and many others. So if we use the same syntax
without any difference, we would have no way of telling if the command is
referring to the pgpool-II or Backend.

like
SHOW port;
This command would be valid for both pgpool-II and PostgreSQL parameter.

Second, I think it's good to have distinction in commands for
setting/showing GUC and pgpool variables, otherwise it could cause the
confusions.




> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> > Hi
> >
> > I am currently working on adding the SHOW and SET commands for pgpool-II
> > configuration parameter, these commands will allow the user to alter the
> > specific pgpool-II configuration parameter values for a user session.
> More
> > or less, these commands will work in similar ways as PostgreSQL's SET and
> > SHOW commands for PostgreSQL's GUC variables. I have already checked in
> the
> > configuration parameter framework to the pgpool master branch and before
> I
> > push the SET and SHOW command functionality I want the opinion on the
> > syntax of these two commands.
> >
> > I am thinking of using the PG's syntax with an addition of PGPOOL keyword
> > at the start
> >
> > For example
> >
> > PostgreSQL uses the following syntax for SHOW and SET command
> >
> > SHOW variable_name;
> > SHOW all;
> > SET variable_name to value;
> > SET variable_name to DEFAULT;
> > ..
> >
> > And for pgpool variables we can use
> >
> > PGPOOL SHOW variable_name;
> > PGPOOL SHOW all;
> > PGPOOL SET variable_name to value;
> > PGPOOL SET variable_name to DEFAULT;
> > ..
> >
> > Suggestions and thoughts.
> >
> > Kind Regards
> > Muhammad Usmaa
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20160506/0bf6a221/attachment-0001.html>