From: jboes@nexcerpt.com
To: pgsql-sql@postgresql.org
Subject: How to recognize trigger-inserted rows?
Date: 26 Oct 2004 10:00:01 -0700
Message-ID: <d40a65a1.0410260900.695a1ac6@posting.google.com> (raw)
I have a table with an INSERT/UPDATE/DELETE statement trigger. The
trigger's action is to insert "jobs" into a queue noting that the
table has changed.
A number of other tables have FK relationships with this table, and
they have their own statement triggers that fire on DELETE.
When I delete a number of rows from the first table, the cascading
deletes into the other tables generate a rather large number of
trigger-fires, so I end up with way too many rows in the queue-table.
What I would like to do is, within the transaction doing the top-level
delete, examine the queue-table for duplicate rows and remove those,
since they are extraneous.
Ideally I would look for rows that have the same transaction ID, but
I'm having trouble determining what the current ID is. I'm using Pg
7.4.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jboes@nexcerpt.com
Subject: Re: How to recognize trigger-inserted rows?
In-Reply-To: <d40a65a1.0410260900.695a1ac6@posting.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox