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

[Tatsuo Ishii]

Usama,

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

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