Re: psql help message contains excessive indentations

2023-09-18 Thread Alvaro Herrera
On 2023-Sep-07, Yugo NAGATA wrote:

> Thank you for your explanation. I understood it. I thought of just
> imitating other places, and I didn't know each is a single translatable
> unit.

Thanks for reviewing, and Kyotaro for reporting.  Pushed now.

-- 
Álvaro HerreraBreisgau, Deutschland  —  https://www.EnterpriseDB.com/
"Estoy de acuerdo contigo en que la verdad absoluta no existe...
El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)




Re: psql help message contains excessive indentations

2023-09-07 Thread Kyotaro Horiguchi
At Thu, 7 Sep 2023 13:06:35 +0200, Alvaro Herrera  
wrote in 
> On 2023-Sep-07, Yugo NAGATA wrote:
> > +   HELP0("  \\watch [[i=]SEC] [c=N] [m=MIN]\n"
> > + " execute query every SEC seconds, up 
> > to N times\n"
> > + " stop if less than MIN rows are 
> > returned\n");
> 
> Yeah, this looks right to me -- the whole help entry as a single
> translatable unit, instead of three separately translatable lines.

+1

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center




Re: psql help message contains excessive indentations

2023-09-07 Thread Yugo NAGATA
On Thu, 7 Sep 2023 13:06:35 +0200
Alvaro Herrera  wrote:

> On 2023-Sep-07, Yugo NAGATA wrote:
> 
> > Yes. So, I mean how about fixing \watch description as the attached patch.
> 
> > diff --git a/src/bin/psql/help.c b/src/bin/psql/help.c
> > index 38c165a627..12280c0e54 100644
> > --- a/src/bin/psql/help.c
> > +++ b/src/bin/psql/help.c
> > @@ -200,9 +200,9 @@ slashUsage(unsigned short int pager)
> > HELP0("  \\gset [PREFIX] execute query and store result in psql 
> > variables\n");
> > HELP0("  \\gx [(OPTIONS)] [FILE] as \\g, but forces expanded output 
> > mode\n");
> > HELP0("  \\q quit psql\n");
> > -   HELP0("  \\watch [[i=]SEC] [c=N] [m=MIN]\n");
> > -   HELP0("  execute query every SEC seconds, up to 
> > N times\n");
> > -   HELP0("  stop if less than MIN rows are 
> > returned\n");
> > +   HELP0("  \\watch [[i=]SEC] [c=N] [m=MIN]\n"
> > + " execute query every SEC seconds, up 
> > to N times\n"
> > + " stop if less than MIN rows are 
> > returned\n");
> 
> Yeah, this looks right to me -- the whole help entry as a single
> translatable unit, instead of three separately translatable lines.

Thank you for your explanation. I understood it. I thought of just
imitating other places, and I didn't know each is a single translatable
unit.

Regards,
Yugo Nagata

> -- 
> Álvaro Herrera   48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
> "Estoy de acuerdo contigo en que la verdad absoluta no existe...
> El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)


-- 
Yugo NAGATA 




Re: psql help message contains excessive indentations

2023-09-07 Thread Alvaro Herrera
On 2023-Sep-07, Yugo NAGATA wrote:

> Yes. So, I mean how about fixing \watch description as the attached patch.

> diff --git a/src/bin/psql/help.c b/src/bin/psql/help.c
> index 38c165a627..12280c0e54 100644
> --- a/src/bin/psql/help.c
> +++ b/src/bin/psql/help.c
> @@ -200,9 +200,9 @@ slashUsage(unsigned short int pager)
>   HELP0("  \\gset [PREFIX] execute query and store result in psql 
> variables\n");
>   HELP0("  \\gx [(OPTIONS)] [FILE] as \\g, but forces expanded output 
> mode\n");
>   HELP0("  \\q quit psql\n");
> - HELP0("  \\watch [[i=]SEC] [c=N] [m=MIN]\n");
> - HELP0("  execute query every SEC seconds, up to 
> N times\n");
> - HELP0("  stop if less than MIN rows are 
> returned\n");
> + HELP0("  \\watch [[i=]SEC] [c=N] [m=MIN]\n"
> +   " execute query every SEC seconds, up 
> to N times\n"
> +   " stop if less than MIN rows are 
> returned\n");

Yeah, this looks right to me -- the whole help entry as a single
translatable unit, instead of three separately translatable lines.

-- 
Álvaro Herrera   48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"Estoy de acuerdo contigo en que la verdad absoluta no existe...
El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)




Re: psql help message contains excessive indentations

2023-09-07 Thread Kyotaro Horiguchi
At Thu, 7 Sep 2023 16:08:10 +0900, Yugo NAGATA  wrote in 
> On Thu, 07 Sep 2023 15:36:10 +0900 (JST)
> Kyotaro Horiguchi  wrote:
> 
> > At Thu, 7 Sep 2023 15:02:49 +0900, Yugo NAGATA  wrote 
> > in 
> > > I wonder this better to fix this in similar way to other places where the
> > > description has multiple lines., like "\g [(OPTIONS)] [FILE]".
> > 
> > It looks correct to me:
> 
> Yes. So, I mean how about fixing \watch description as the attached patch.

Ah. I see. I thought you meant that line needed the same change.

> > 
> > >  \errverboseshow most recent error message at maximum 
> > > verbosity
> > >  \g [(OPTIONS)] [FILE]  execute query (and send result to file or |pipe);
> > > \g with no arguments is equivalent to a semicolon
> > >  \gdesc describe result of query, without executing it

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center




Re: psql help message contains excessive indentations

2023-09-07 Thread Yugo NAGATA
On Thu, 07 Sep 2023 15:36:10 +0900 (JST)
Kyotaro Horiguchi  wrote:

> At Thu, 7 Sep 2023 15:02:49 +0900, Yugo NAGATA  wrote in 
> > On Thu, 07 Sep 2023 14:29:56 +0900 (JST)
> > Kyotaro Horiguchi  wrote:
> > >  >  \q quit psql
> > >  >  \watch [[i=]SEC] [c=N] [m=MIN]
> > > !>  execute query every SEC seconds, up to N times
> > > !>  stop if less than MIN rows are returned
> > > 
> > > The last two lines definitely have some extra indentation.
> > 
> > Agreed.
> > 
> > > I've attached a patch that fixes this.
> > 
> > I wonder this better to fix this in similar way to other places where the
> > description has multiple lines., like "\g [(OPTIONS)] [FILE]".
> 
> It looks correct to me:

Yes. So, I mean how about fixing \watch description as the attached patch.

> 
> >  \errverboseshow most recent error message at maximum verbosity
> >  \g [(OPTIONS)] [FILE]  execute query (and send result to file or |pipe);
> > \g with no arguments is equivalent to a semicolon
> >  \gdesc describe result of query, without executing it
> 
> regards.
> 
> -- 
> Kyotaro Horiguchi
> NTT Open Source Software Center


-- 
Yugo NAGATA 
diff --git a/src/bin/psql/help.c b/src/bin/psql/help.c
index 38c165a627..12280c0e54 100644
--- a/src/bin/psql/help.c
+++ b/src/bin/psql/help.c
@@ -200,9 +200,9 @@ slashUsage(unsigned short int pager)
 	HELP0("  \\gset [PREFIX] execute query and store result in psql variables\n");
 	HELP0("  \\gx [(OPTIONS)] [FILE] as \\g, but forces expanded output mode\n");
 	HELP0("  \\q quit psql\n");
-	HELP0("  \\watch [[i=]SEC] [c=N] [m=MIN]\n");
-	HELP0("  execute query every SEC seconds, up to N times\n");
-	HELP0("  stop if less than MIN rows are returned\n");
+	HELP0("  \\watch [[i=]SEC] [c=N] [m=MIN]\n"
+		  " execute query every SEC seconds, up to N times\n"
+		  " stop if less than MIN rows are returned\n");
 	HELP0("\n");
 
 	HELP0("Help\n");


Re: psql help message contains excessive indentations

2023-09-07 Thread Kyotaro Horiguchi
At Thu, 7 Sep 2023 15:02:49 +0900, Yugo NAGATA  wrote in 
> On Thu, 07 Sep 2023 14:29:56 +0900 (JST)
> Kyotaro Horiguchi  wrote:
> >  >  \q quit psql
> >  >  \watch [[i=]SEC] [c=N] [m=MIN]
> > !>  execute query every SEC seconds, up to N times
> > !>  stop if less than MIN rows are returned
> > 
> > The last two lines definitely have some extra indentation.
> 
> Agreed.
> 
> > I've attached a patch that fixes this.
> 
> I wonder this better to fix this in similar way to other places where the
> description has multiple lines., like "\g [(OPTIONS)] [FILE]".

It looks correct to me:

>  \errverboseshow most recent error message at maximum verbosity
>  \g [(OPTIONS)] [FILE]  execute query (and send result to file or |pipe);
> \g with no arguments is equivalent to a semicolon
>  \gdesc describe result of query, without executing it

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center




Re: psql help message contains excessive indentations

2023-09-07 Thread Yugo NAGATA
On Thu, 07 Sep 2023 14:29:56 +0900 (JST)
Kyotaro Horiguchi  wrote:

> This topic is extracted from [1].
> 
> As mentioned there, in psql, running \? displays the following lines.
> 
>  >  \gdesc describe result of query, without executing it
>  >  \gexec execute query, then execute each value in its 
> result
>  >  \gset [PREFIX] execute query and store result in psql variables
>  >  \gx [(OPTIONS)] [FILE] as \g, but forces expanded output mode
>  >  \q quit psql
>  >  \watch [[i=]SEC] [c=N] [m=MIN]
> !>  execute query every SEC seconds, up to N times
> !>  stop if less than MIN rows are returned
> 
> The last two lines definitely have some extra indentation.

Agreed.

> I've attached a patch that fixes this.

I wonder this better to fix this in similar way to other places where the
description has multiple lines., like "\g [(OPTIONS)] [FILE]".

Regards,
Yugo Nagata

> 
> [1] 
> https://www.postgresql.org/message-id/20230830.103356.1909699532104167477.horikyota@gmail.com
> 
> regards.
> 
> -- 
> Kyotaro Horiguchi
> NTT Open Source Software Center


-- 
Yugo NAGATA 




psql help message contains excessive indentations

2023-09-06 Thread Kyotaro Horiguchi
This topic is extracted from [1].

As mentioned there, in psql, running \? displays the following lines.

 >  \gdesc describe result of query, without executing it
 >  \gexec execute query, then execute each value in its result
 >  \gset [PREFIX] execute query and store result in psql variables
 >  \gx [(OPTIONS)] [FILE] as \g, but forces expanded output mode
 >  \q quit psql
 >  \watch [[i=]SEC] [c=N] [m=MIN]
!>  execute query every SEC seconds, up to N times
!>  stop if less than MIN rows are returned

The last two lines definitely have some extra indentation.
I've attached a patch that fixes this.

[1] 
https://www.postgresql.org/message-id/20230830.103356.1909699532104167477.horikyota@gmail.com

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center
diff --git a/src/bin/psql/help.c b/src/bin/psql/help.c
index 38c165a627..f8eeef8e4e 100644
--- a/src/bin/psql/help.c
+++ b/src/bin/psql/help.c
@@ -201,8 +201,8 @@ slashUsage(unsigned short int pager)
 	HELP0("  \\gx [(OPTIONS)] [FILE] as \\g, but forces expanded output mode\n");
 	HELP0("  \\q quit psql\n");
 	HELP0("  \\watch [[i=]SEC] [c=N] [m=MIN]\n");
-	HELP0("  execute query every SEC seconds, up to N times\n");
-	HELP0("  stop if less than MIN rows are returned\n");
+	HELP0(" execute query every SEC seconds, up to N times\n");
+	HELP0(" stop if less than MIN rows are returned\n");
 	HELP0("\n");
 
 	HELP0("Help\n");