David G. Johnston wrote:
> In hindsight I'm not surprised but couldn't find a ready explanation on the web and
> figured I'd inquire here. In short: "export VAR" and "export -f functionname" behave
> differently when psql is acting as a relay.
It works for me on Linux with 9.6.3 psql:
Except you haven't recreated the scenario I presented.
You only are involving a single script and that script defines "testfunction" itself (which makes exporting pointless). In my example the script being executed within the psql script does not define testfunction itself.
-> == execute in subshell
main-script (def func) -> psql -> psql-call-bash (invoke func)
David J.
