Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Monday, March 21, 2016, Tom Lane wrote: > "David G. Johnston" > writes: > > On Monday, March 21, 2016, Tom Lane > > wrote: > >> What about just discarding the old format entirely, and printing one

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Tue, Mar 22, 2016 at 6:25 AM, Tom Lane wrote: > If I don't hear objections PDQ, I'm going to update the docs and commit > it like that. Thanks! -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

Tom Lane wrote: > "David G. Johnston" writes: > > On Monday, March 21, 2016, Tom Lane wrote: > >> What about just discarding the old format entirely, and printing one of > >> these two things: > >> > >> Timestamp (every Ns) > >> > >> User Given

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

"David G. Johnston" writes: > On Monday, March 21, 2016, Tom Lane wrote: >> What about just discarding the old format entirely, and printing one of >> these two things: >> >> Timestamp (every Ns) >> >> User Given Title Timestamp (every Ns) >

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Monday, March 21, 2016, Tom Lane wrote: > "David G. Johnston" > writes: > > I'll admit it's awkward because it's abbreviated but if someone enters > > \watch 5 and then sees (5s) in the title I think they can put two and two > >

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Monday, March 21, 2016, Robert Haas wrote: > On Mon, Mar 21, 2016 at 2:09 PM, David G. Johnston > > wrote: > > On Monday, March 21, 2016, Tom Lane > > wrote: > >> "David G. Johnston"

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Mon, Mar 21, 2016 at 2:09 PM, David G. Johnston wrote: > On Monday, March 21, 2016, Tom Lane wrote: >> "David G. Johnston" writes: >> > I'd rather not omit sleep but removing "Watch every" is fine (preferred >> >

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Monday, March 21, 2016, Tom Lane wrote: > "David G. Johnston" > writes: > > I'd rather not omit sleep but removing "Watch every" is fine (preferred > > actually), so: > > Title Is Here Mon Mar 21 15:05:06 2016 (5s) > > Meh ...

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

"David G. Johnston" writes: > I'd rather not omit sleep but removing "Watch every" is fine (preferred > actually), so: > Title Is Here Mon Mar 21 15:05:06 2016 (5s) Meh ... seems a bit awkward to me. Couldn't you include " (5s)" in the title, if you want that

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

On Mon, Mar 21, 2016 at 10:14 AM, Tom Lane wrote: > Robert Haas writes: > > Well, the title isn't normally centered, but yeah, that is odd. Yeah, > > that is odd. Come to think of it, I think I might have expected the > > title to appear *above*

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

Robert Haas writes: > Well, the title isn't normally centered, but yeah, that is odd. Yeah, > that is odd. Come to think of it, I think I might have expected the > title to appear *above* "Watch every %s", not below it. That might > decrease the oddness. AFAICS, it

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

On Mon, Mar 21, 2016 at 11:17 AM, David G. Johnston wrote: >> And does everybody agree that this is a desirable change? > > Adding the title is desirable. While I'm inclined to bike-shed this > anything that gets it in I can live with and so I'm content letting the >

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

On Mon, Mar 21, 2016 at 8:03 AM, Robert Haas wrote: > On Sun, Mar 20, 2016 at 9:31 AM, Michael Paquier > wrote: > > And the patch attached gives the following output: > > With title: > > =# \watch 1 > > Watch every 1sSun Mar 20 22:28:38 2016

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

On Sun, Mar 20, 2016 at 9:31 AM, Michael Paquier wrote: > And the patch attached gives the following output: > With title: > =# \watch 1 > Watch every 1sSun Mar 20 22:28:38 2016 > popo > a > --- > 1 > (1 row) > > And without title: > Watch every 1sSun Mar 20

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

On Sat, Mar 19, 2016 at 11:42 PM, Robert Haas wrote: > On Thu, Mar 10, 2016 at 1:40 AM, David G. Johnston > wrote: >> Adding -hackers for consideration in the Commitfest. > > I don't much like how this patch uses the arbitrary constant 50 in no

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

David Steele writes: > On 3/17/16 5:07 PM, David G. Johnston wrote: >> Figured out it had to be added to 2016-09...done > Hmm ... this patch is currently marked "needs review" in CF 2016-03. Am > I missing something, should this have been closed? The message I saw was

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

On Fri, Mar 18, 2016 at 8:16 AM, Tom Lane wrote: > David Steele writes: >> On 3/17/16 7:00 PM, Tom Lane wrote: >>> The message I saw was post-1-March. If it was in fact submitted in >>> time for 2016-03, then we owe it a review. > >> I meant to add the

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

rom: Michael Paquier <michael.paqu...@gmail.com> > Date: Thu, Jan 28, 2016 at 6:01 AM > Subject: Re: [GENERAL] Request - repeat value of \pset title during \watch > interations > To: "David G. Johnston" <david.g.johns...@gmail.com> > Cc: Tom Lane <t...@ss

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

On Thu, Mar 10, 2016 at 1:40 AM, David G. Johnston wrote: > Adding -hackers for consideration in the Commitfest. I don't much like how this patch uses the arbitrary constant 50 in no fewer than 5 locations. Also, it seems like we could arrange for head_title to be ""

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

On 3/17/16 7:00 PM, Tom Lane wrote: > David Steele writes: >> On 3/17/16 5:07 PM, David G. Johnston wrote: >>> Figured out it had to be added to 2016-09...done > >> Hmm ... this patch is currently marked "needs review" in CF 2016-03. Am >> I missing something, should this

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

On 3/17/16 5:07 PM, David G. Johnston wrote: > Figured out it had to be added to 2016-09...done Hmm ... this patch is currently marked "needs review" in CF 2016-03. Am I missing something, should this have been closed? -- -David da...@pgmasters.net -- Sent via pgsql-general mailing list

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Thursday, March 17, 2016, Michael Paquier wrote: > On Fri, Mar 18, 2016 at 8:16 AM, Tom Lane > wrote: > > David Steele > writes: > >> On 3/17/16 7:00 PM, Tom Lane wrote: > >>> The message I saw

Re: [HACKERS] [GENERAL] Request - repeat value of \pset title during \watch interations

David Steele writes: > On 3/17/16 7:00 PM, Tom Lane wrote: >> The message I saw was post-1-March. If it was in fact submitted in >> time for 2016-03, then we owe it a review. > I meant to add the CF record and forgot: > https://commitfest.postgresql.org/9/480 > It was added

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

tion into the title. -- Forwarded message -- From: Michael Paquier <michael.paqu...@gmail.com> Date: Thu, Jan 28, 2016 at 6:01 AM Subject: Re: [GENERAL] Request - repeat value of \pset title during \watch interations To: "David G. Johnston" <david.g.johns...@gmail

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Thu, Jan 28, 2016 at 9:07 PM, Michael Paquier wrote: > > > On Fri, Jan 29, 2016 at 1:55 AM, David G. Johnston wrote: > > Could you run the following and post the result, please? I have yet to > > setup a compiled-from-source installation... > > > > \pset title

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Thu, Jan 28, 2016 at 6:01 AM, Michael Paquier wrote: > On Thu, Jan 28, 2016 at 1:54 PM, David G. Johnston > wrote: > > On Wed, Jan 27, 2016 at 9:13 PM, Michael Paquier < > michael.paqu...@gmail.com> > > wrote: > >> > >> On Thu, Jan 28,

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Thu, Jan 28, 2016 at 1:54 PM, David G. Johnston wrote: > On Wed, Jan 27, 2016 at 9:13 PM, Michael Paquier > wrote: >> >> On Thu, Jan 28, 2016 at 9:34 AM, David G. Johnston >> wrote: >> > So how about: >> > >>

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Fri, Jan 29, 2016 at 1:55 AM, David G. Johnston wrote: > Could you run the following and post the result, please? I have yet to > setup a compiled-from-source installation... > > \pset title 'This is a medium length title' > SELECT repeat('a', 100) \watch 5 > > It seems fine though I'm curious

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Wed, Jan 27, 2016 at 9:13 PM, Michael Paquier wrote: > On Thu, Jan 28, 2016 at 9:34 AM, David G. Johnston > wrote: > > So how about: > > > > + snprintf(title, strlen(myopt.title) + 50, > > + _("Watch every %lds\t%s\t%s"), > > + sleep,

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Thu, Jan 28, 2016 at 9:34 AM, David G. Johnston wrote: > So how about: > > + snprintf(title, strlen(myopt.title) + 50, > + _("Watch every %lds\t%s\t%s"), > + sleep, head_title, asctime(localtime())); I would just keep the timestamp and the title separated so what

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Mon, Jan 11, 2016 at 9:55 PM, Michael Paquier wrote: > On Tue, Jan 12, 2016 at 1:15 AM, David G. Johnston > wrote: > > On Mon, Jan 11, 2016 at 9:03 AM, Tom Lane wrote: > >> > >> "David G. Johnston"

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Tue, Jan 12, 2016 at 1:15 AM, David G. Johnston wrote: > On Mon, Jan 11, 2016 at 9:03 AM, Tom Lane wrote: >> >> "David G. Johnston" writes: >> > On Mon, Jan 11, 2016 at 8:14 AM, Tom Lane wrote:

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Mon, Jan 11, 2016 at 3:36 AM, David G. Johnston wrote: > When executing a query using \watch in psql the first execution of the query > includes "Title is [...]" when \pset title is in use. Subsequent executions > do not. Once that first display goes off-screen

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Mon, Jan 11, 2016 at 9:03 AM, Tom Lane wrote: > "David G. Johnston" writes: > > On Mon, Jan 11, 2016 at 8:14 AM, Tom Lane wrote: > >> Perhaps we should replace the "Watch every Ns" text by the user-given > >> title if a

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Mon, Jan 11, 2016 at 8:14 AM, Tom Lane wrote: > Michael Paquier writes: > > On Mon, Jan 11, 2016 at 3:36 AM, David G. Johnston > > wrote: > >> When executing a query using \watch in psql the first execution of the >

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

Michael Paquier writes: > On Mon, Jan 11, 2016 at 3:36 AM, David G. Johnston > wrote: >> When executing a query using \watch in psql the first execution of the query >> includes "Title is [...]" when \pset title is in use. Subsequent

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

"David G. Johnston" writes: > On Mon, Jan 11, 2016 at 8:14 AM, Tom Lane wrote: >> Perhaps we should replace the "Watch every Ns" text by the user-given >> title if a title has been set? That would conserve screen space. > ​The extra line

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

On Mon, Jan 11, 2016 at 4:14 AM, Michael Paquier wrote: > On Mon, Jan 11, 2016 at 3:36 AM, David G. Johnston > wrote: > > When executing a query using \watch in psql the first execution of the > query > > includes "Title is [...]" when

[GENERAL] Request - repeat value of \pset title during \watch interations

When executing a query using \watch in psql the first execution of the query includes "Title is [...]" when \pset title is in use. Subsequent executions do not. Once that first display goes off-screen the information in the title is no longer readily accessible. If using \watch for a