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

2016-03-21 Thread David G. Johnston
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

2016-03-21 Thread Michael Paquier
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: [GENERAL] Request - repeat value of \pset title during \watch interations

2016-03-21 Thread Tom Lane
"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

2016-03-21 Thread David G. Johnston
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

2016-03-21 Thread David G. Johnston
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

2016-03-21 Thread Robert Haas
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

2016-03-21 Thread David G. Johnston
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: [GENERAL] Request - repeat value of \pset title during \watch interations

2016-03-19 Thread David G. Johnston
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: [GENERAL] Request - repeat value of \pset title during \watch interations

2016-03-18 Thread David G. Johnston
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: [GENERAL] Request - repeat value of \pset title during \watch interations

2016-03-09 Thread David G. Johnston
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

2016-01-29 Thread David G. Johnston
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

2016-01-28 Thread David G. Johnston
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

2016-01-28 Thread Michael Paquier
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

2016-01-28 Thread Michael Paquier
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

2016-01-27 Thread David G. Johnston
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

2016-01-27 Thread Michael Paquier
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

2016-01-27 Thread David G. Johnston
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

2016-01-11 Thread Michael Paquier
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

2016-01-11 Thread Michael Paquier
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

2016-01-11 Thread David G. Johnston
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

2016-01-11 Thread David G. Johnston
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

2016-01-11 Thread Tom Lane
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

2016-01-11 Thread Tom Lane
"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

2016-01-11 Thread David G. Johnston
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