X-Received: by 2002:a05:622a:19a5:b0:410:6ea4:9662 with SMTP id u37-20020a05622a19a500b004106ea49662mr25071qtc.2.1694588016671; Tue, 12 Sep 2023 23:53:36 -0700 (PDT)
X-Received: by 2002:a05:6870:c7a8:b0:1d5:8fa2:e777 with SMTP id dy40-20020a056870c7a800b001d58fa2e777mr639679oab.5.1694588016457; Tue, 12 Sep 2023 23:53:36 -0700 (PDT)
Path: csiph.com!1.us.feeder.erje.net!feeder.erje.net!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Tue, 12 Sep 2023 23:53:35 -0700 (PDT)
In-Reply-To: <80ea7a3c-5dab-48ed-bc0d-cd39836ef4ecn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=93.63.171.9; posting-account=o45aTQoAAAC0zpFKFFtE1KNZ5g5HYdBB
NNTP-Posting-Host: 93.63.171.9
References: <757cd439-a568-4385-ad7e-b1bb6bf12a97n@googlegroups.com> <80ea7a3c-5dab-48ed-bc0d-cd39836ef4ecn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <442e0ed1-b216-4d64-b400-3e0b707fc22en@googlegroups.com>
Subject: Re: Triggers and locks
From: Fabrizio Di Renzo <fabrizio.direnzo@bucap.it>
Injection-Date: Wed, 13 Sep 2023 06:53:36 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1461
Xref: csiph.com comp.databases.ingres:3898

Thank you all,
we will try to use dbevent, I think this is a good idea.
We never used it, but it seem the better solution.

> ps. your AFTER INSERT rule looks like it needs to refer to the new record rather than the old record?

We need to refer to old record

Fabrizio