On Mon, 2024-12-02 at 18:49 -0500, punch-hassle-guise@duck.com wrote:
> The problem seems to be, as alluded to by others attempting to help me
> that the problem only exists when using -c on the same line as -v.
> I am guessing here, that my original question should have been:
>
> "Why is it okay to use a psql variable declared on a command line in a psql session
> that was started from said command line and not with a session that was created and
> destroyed with a -c command switch?"
"Why" questions tend to be difficult to answer.
The simple answer is: because somebody implemented it that way.
I dug into the commit history, and the current behavior seems to stem from commit
a45195a191 from 1999 that introduced psql variables and has the lapidary commit
message "Major psql overhaul by Peter Eisentraut".
I couldn't find a pertinent discussion on the list.
If you dislike the current behavior enough, you could write a patch that changes
it. There might be some resistence, however, because a behavoir change like that
could break existing scripts and persent a backward incompatibility.
Yours,
Laurenz Albe
