MIME-Version: 1.0
References: <CAD=mzVU0rx4A0onfC4jHxZ7XreZrk9DNa9pFoGDOjPD1ZhfHgw@mail.gmail.com>
 <85cc2eb0ca709ab753e618584f46dbf8801e9658.camel@cybertec.at> <CAD=mzVVOC=H9zhYn5YF74XMV+7023f5hPvcroSaQu61m7q-yCg@mail.gmail.com>
In-Reply-To: <CAD=mzVVOC=H9zhYn5YF74XMV+7023f5hPvcroSaQu61m7q-yCg@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 30 Jul 2024 13:28:35 -0700
Message-ID: <CAKFQuwakdL3D-0wkiou11ahxCtyMkCoraVZFu-bkmJ=NH8cJ2w@mail.gmail.com>
Subject: Re: Trigger usecase
To: sud <suds1434@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, 
	pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b17f07061e7cd4e1"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwakdL3D-0wkiou11ahxCtyMkCoraVZFu-bkmJ%3DNH8cJ2w%40mail.gmail.com>
Precedence: bulk

--000000000000b17f07061e7cd4e1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Jul 30, 2024 at 11:46=E2=80=AFAM sud <suds1434@gmail.com> wrote:

>
> Not sure of the exact pros and cons, but we were following certain rules
> like , if it's business logic which needs to be implemented in Database,
> then it should not be done using triggers but rather should be done throu=
gh
> database procedure/functions. Hope this understanding correct.
>

That is my personal take.  For process-oriented stuff you can follow the
trail of calls all the way through to the end of the process and its final
result.  With triggers you follow the trail to the insert/update/delete
then stop thinking that's it, while in reality it continues because you
have triggers performing yet more work.

David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, Jul 30, 2024 at 11:46=E2=80=AFAM sud &lt;<a href=
=3D"mailto:suds1434@gmail.com">suds1434@gmail.com</a>&gt; wrote:</span><br>=
</div></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd=
ing-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><br></div><div class=3D"gma=
il_quote"><div>Not sure of the exact pros and cons, but we were following c=
ertain rules like , if it&#39;s business logic which needs to be implemente=
d in Database, then it should not be done using triggers but rather should =
be done through database procedure/functions. Hope this understanding=C2=A0=
correct.</div></div></div></blockquote><div><br></div><div class=3D"gmail_d=
efault" style=3D"font-family:arial,helvetica,sans-serif">That is my persona=
l take.=C2=A0 For process-oriented stuff you can follow the trail of calls =
all the way through to the end of the process and its final result.=C2=A0 W=
ith triggers you follow the trail to the insert/update/delete then stop thi=
nking that&#39;s it, while in reality it continues because you have trigger=
s performing yet more work.</div><div class=3D"gmail_default" style=3D"font=
-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" =
style=3D"font-family:arial,helvetica,sans-serif">David J.</div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></d=
iv></div></div>

--000000000000b17f07061e7cd4e1--