From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: shekhar.salunkhe@capgemini.com
Subject: BUG #18584: Triggers are not fired or executing when any DML transaction runs
Date: Sat, 17 Aug 2024 09:41:32 +0000
Message-ID: <18584-e2d0156c6a1dc671@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18584
Logged by: Shekhar Salunkhe
Email address: shekhar.salunkhe@capgemini.com
PostgreSQL version: 16.2
Operating system: Linux
Description:
Trigger should get automatically executed once DML operation
invoke/completed.
I have converted Oracle code using AWS Shema Conversion tool to Postgres
16.1 (In this version triggers are executing completely fine).
Similarly, I have converted Oracle code using AWS Schema Conversion tool
into Postgres 16.2 however we have observed not a single trigger executed
after DML operation.
Further I have created simple new table and trigger on it, still it is not
invoked after update statement.
I also compared other Database parameter with 16.1 vs 16.2 where only
"session_replication_role" was set as "replica" in 16.2. This parameter now
set as "Origin" but still triggers are not working.
I am completely blocked to test further scenarios.
I have provided required grants "SELECT, INSERT, UPDATE, DELETE, TRUNCATE,
REFERENCES, TRIGGER" of that table to user. Provided all usage schema to
that user. Given ownership of trigger functions to that user.
Still there is no trigger executed except insert / update / delete operation
runs OK.
Request you to please help me out.
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-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, shekhar.salunkhe@capgemini.com
Subject: Re: BUG #18584: Triggers are not fired or executing when any DML transaction runs
In-Reply-To: <18584-e2d0156c6a1dc671@postgresql.org>
* 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