Groups | Search | Server Info | Login | Register


Groups > comp.databases.ingres > #3898

Re: Triggers and locks

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> (permalink)
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

Show key headers only | View raw


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

Back to comp.databases.ingres | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

Triggers and locks Fabrizio Di Renzo <fabrizio.direnzo@bucap.it> - 2023-09-12 02:40 -0700
  Re: Triggers and locks Roy Hann <specially@processed.almost.meat> - 2023-09-12 10:36 +0000
    Re: Triggers and locks G Jones <geraint.jones@ndph.ox.ac.uk> - 2023-09-12 07:41 -0700
  Re: Triggers and locks Paul White <shift7solutions@gmail.com> - 2023-09-12 22:03 -0700
    Re: Triggers and locks Fabrizio Di Renzo <fabrizio.direnzo@bucap.it> - 2023-09-12 23:53 -0700
      Re: Triggers and locks Roy Hann <specially@processed.almost.meat> - 2023-09-13 08:54 +0000

csiph-web