From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | access to psql variables from server again |
Date: | 2012-07-29 05:53:52 |
Message-ID: | CAFj8pRASdzBsJ7TRxZ_bPUjj2Srje2T_Ay7hT86d3aBqtWgaCA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello
I am returning to topic, that I opened with discussion about enhancing
protocol to support access to host variables.
There was a second idea about joining host variables and session
variables. This can be implemented without protocol enhancing, but it
is only one way tool - we are able read host parameters only on start
- but we can simply forward changes of session variables to host. I
have another idea - just for psql. We can define two commands to copy
psql variable to server and from server to psql. This mechanism is
very simple and robust. There is not problem with security or some
unwanted overhead.
\vf hostvar [ sessionvar ] -- variable forward
\vl hostvar [ sessionvar ] -- variable load
Name of session variable is optional, when is not specified, then
"host"."hostvar" is used.
Ideas, comments?
Regards
Pavel
From | Date | Subject | |
---|---|---|---|
Next Message | Satoshi Nagayasu | 2012-07-29 08:06:39 | Re: Adding probes for smgr |
Previous Message | Amit kapila | 2012-07-29 05:00:20 | Re: external_pid_file not removed on postmaster exit |