access to psql variables from server again - Mailing list pgsql-hackers

From Pavel Stehule
Subject access to psql variables from server again
Date
Msg-id CAFj8pRASdzBsJ7TRxZ_bPUjj2Srje2T_Ay7hT86d3aBqtWgaCA@mail.gmail.com
Whole thread Raw
List 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


pgsql-hackers by date:

Previous
From: Amit kapila
Date:
Subject: Re: external_pid_file not removed on postmaster exit
Next
From: Satoshi Nagayasu
Date:
Subject: Re: Adding probes for smgr