MIME-Version: 1.0
References: <DM8PR09MB6677887ED1DA5D9494E2055CB85E2@DM8PR09MB6677.namprd09.prod.outlook.com>
In-Reply-To: <DM8PR09MB6677887ED1DA5D9494E2055CB85E2@DM8PR09MB6677.namprd09.prod.outlook.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Sun, 10 Nov 2024 09:55:34 -0500
Message-ID: <CAKAnmmL2ib1=-x-kpqaWPL6RoLa4qbeFWAeSGEB5SZ2pyeTLPA@mail.gmail.com>
Subject: Re: Bash function from psql (v14)
To: Murthy Nunna <mnunna@fnal.gov>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003af8ac0626902f24"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmL2ib1%3D-x-kpqaWPL6RoLa4qbeFWAeSGEB5SZ2pyeTLPA%40mail.gmail.com>
Precedence: bulk

--0000000000003af8ac0626902f24
Content-Type: text/plain; charset="UTF-8"

What problem are you trying to solve? If you tell us that, we can guide you
to some better solutions.

There are numerous issues here, but the most important are:

1) Calling a shell via \! invokes an entirely new process: there is no link
to the parent or grandparent process

2) The run-bash-function must be declared before being called, so that bash
code was never going to work anyway. In other words, this is valid:

run-bash-function() { echo "Here we are"; }

run-bash-function

This version is not:

run-bash-function

run-bash-function() { echo "Here we are"; }


Cheers,
Greg

--0000000000003af8ac0626902f24
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">What problem are you trying to solve? If you tell us that,=
 we can guide you to some better solutions.<div><br><div>There are numerous=
 issues here, but the most important are:<div><br></div><div>1) Calling a s=
hell via \! invokes an entirely new process: there is no link to the parent=
 or grandparent process</div><div><br></div><div>2) The run-bash-function m=
ust be declared before being called, so that bash code was never going to w=
ork anyway. In other words, this is valid:</div><div><br></div><div>run-bas=
h-function() { echo &quot;Here we are&quot;; }<br><br>run-bash-function</di=
v><div><br></div><div>This version is not:</div><div><br></div><div><div>ru=
n-bash-function</div><div><br></div></div><div>run-bash-function() { echo &=
quot;Here we are&quot;; }<br><br></div><div><br></div></div></div><div>Chee=
rs,</div><div>Greg</div><div><br></div></div>

--0000000000003af8ac0626902f24--