pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #18584: Triggers are not fired or executing when any DML transaction runs 2+ messages / 2 participants [nested] [flat]
* BUG #18584: Triggers are not fired or executing when any DML transaction runs @ 2024-08-17 09:41 PG Bug reporting form <noreply@postgresql.org> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2024-08-17 09:41 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: shekhar.salunkhe@capgemini.com 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18584: Triggers are not fired or executing when any DML transaction runs @ 2024-08-17 16:37 David G. Johnston <david.g.johnston@gmail.com> parent: PG Bug reporting form <noreply@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: David G. Johnston @ 2024-08-17 16:37 UTC (permalink / raw) To: shekhar.salunkhe@capgemini.com; pgsql-bugs@lists.postgresql.org On Sat, Aug 17, 2024 at 9:15 AM PG Bug reporting form < noreply@postgresql.org> wrote: > 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. The buildfarm proves that a stock community 16.2 install has functioning triggers. Whatever is going on is specific to your situation and most likely not a bug. I'd suggest posting for help to -general with more details including the evidence for the simple test you performed below. Further I have created simple new table and trigger on it, still it is not > invoked after update statement. > [...] > 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. > None of those actions are expected to make a difference. You would have seen permission errors if they were relevant. David J. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-08-17 16:37 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-08-17 09:41 BUG #18584: Triggers are not fired or executing when any DML transaction runs PG Bug reporting form <noreply@postgresql.org> 2024-08-17 16:37 ` David G. Johnston <david.g.johnston@gmail.com>
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