access to psql variables from server again

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

Browse pgsql-hackers by date

  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