Re: psql color hostname prompt

Поиск
Список
Период
Сортировка
От Cal Heldenbrand
Тема Re: psql color hostname prompt
Дата
Msg-id CAAcwKheywkdMgGeU=gczDGxxc3b3U2hUik7i2ShkjGF2=rK4=Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql color hostname prompt  (Francisco Olarte <folarte@peoplecall.com>)
Ответы Re: psql color hostname prompt  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: psql color hostname prompt  (Francisco Olarte <folarte@peoplecall.com>)
Список pgsql-general
Thanks for the input everyone.  I'll try to comment on each discussion point:

1) garbled output in large queries

I messed around with a few things, and have not been able to recreate any issues.  Can you provide a test case for this?  Also, any other interesting things about your terminal, like your $TERM setting, locale, etc.  (I'm using xterm with UTF-8, and KDE's Konsole app)


2)  %M vs shell call

%M on when connected to the local machine displays the string "[local]" which I didn't like.  I wanted a real hostname to show no matter which client/server pair I was using.  Zero chance for mistaken commands on the wrong host.  Many times we ssh to a remote server, then run psql locally.

Perhaps the more elegant route here, is to change psql's behavior with %M when connected to the local machine?  (This would also solve point #3)

3)  a forked process for every prompt

While this also isn't very elegant, it seems to work fine.  It's not something to worry about these days when the server has 40 cores.  ;-)   But, I've noticed that different distros store lsof in different locations, so per-environment tweaking might be necessary.

It would be nice if there was a way to do some kind of templating script with the psqlrc file.  Something that would dynamically generate the "\set PROMPT" commands on psql startup, rather than calling out to a shell every command.  (I'm thinking along the lines of ERB for Ruby, Django for Python, etc.) 

But again, I think the more elegant approach is to alter the %M logic.

Any thoughts?

Thanks!

--Cal

On Mon, Apr 25, 2016 at 9:39 AM, Francisco Olarte <folarte@peoplecall.com> wrote:
Hi:

On Mon, Apr 25, 2016 at 4:04 PM, Achilleas Mantzios
<achill@matrix.gatewaynet.com> wrote:
> Hello, have done that, looked really nice, but unfortunately this resulted
> in a lot of garbled output, in case of editing functions, huge queries, up
> arrows, etc...

Did you  use %[ %] to delimit non-printing sequences as Cal did? I've
tested his prompt ( substituting 'echo tarari' for his sh script ) and
it works fine ( at least in xfce4-terminal / ubuntu / 6 terminal lines
long input line ). I've seen a lot of color prompts worked by
forgetting them ( even when the doc for them specially speaks of color
changes ).
Frnacisco Olarte.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Problems running the WorkerSpi sample
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: psql color hostname prompt