MIME-Version: 1.0
In-Reply-To: <CAFCRh-8cwTFBeTS2_7n97e5C42i-pTVw5o+vyqnwxesQFLbp_A@mail.gmail.com>
References: <CAFCRh-8cwTFBeTS2_7n97e5C42i-pTVw5o+vyqnwxesQFLbp_A@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 11 Jun 2024 08:29:36 -0700
Message-ID: <CAKFQuwZmFnYiQquMrxRvu-qOUR_XFXNhioSk30veoMKXb=UxLg@mail.gmail.com>
Subject: Re: Unexpected Backend PID reported by Notification
To: Dominique Devienne <ddevienne@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001049ce061a9eef06"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZmFnYiQquMrxRvu-qOUR_XFXNhioSk30veoMKXb%3DUxLg%40mail.gmail.com>
Precedence: bulk

--0000000000001049ce061a9eef06
Content-Type: text/plain; charset="UTF-8"

On Tuesday, June 11, 2024, Dominique Devienne <ddevienne@gmail.com> wrote:

>
> Are Stored PROCs running in a different backend?
> Are Triggers running in a different backend?
>

No to both.  Whatever backend the SQL to invoke those was sent on is the
backend that executes them.

David J.

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

On Tuesday, June 11, 2024, Dominique Devienne &lt;<a href=3D"mailto:ddevien=
ne@gmail.com">ddevienne@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gm=
ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le=
ft:1ex"><br>
Are Stored PROCs running in a different backend?<br>
Are Triggers running in a different backend?<br>
</blockquote><div><br></div><div>No to both.=C2=A0 Whatever backend the SQL=
 to invoke those was sent on is the backend that executes them.</div><div><=
br></div><div>David J.=C2=A0</div>

--0000000000001049ce061a9eef06--