Trigger Not working in PostgreSQL 13.12 (PAAS)

Sudhan R, Madhu 0

The trigger is not working in Postgres 13 (PAAS) but in the standalone Postgres 13 the triggers are working. The trigger is unable to call the respective function which will perform the insert from one table to another. Not getting any error also.

Basic Trigger example (https://www.postgresqltutorial.com/postgresql-triggers/creating-first-trigger-postgresql/) also not working.

Please suggest option for the same.

GeethaThatipatri-MSFT 27,567 Reputation points Microsoft Employee

2024-03-07T15:38:51.7733333+00:00

Hi, @Sudhan R, Madhu Welcome to Microsoft Q&A thanks for posting your question.

Let me repro the issue in Postgres 13 and provide you with more details.

Regards

Geetha
GeethaThatipatri-MSFT 27,567 Reputation points Microsoft Employee

2024-03-07T21:35:52.4166667+00:00

Hi, @Sudhan R, Madhu I was able to create trigger successfully.

Regards

Geetha
Sudhan R, Madhu 0 Reputation points

2024-03-11T07:01:23.8033333+00:00

Hi @GeethaThatipatri-MSFT ,

I am also able to create the trigger but the functionality is not working. The second table data is not getting modified when there is any change in first table (As per the example link).
Sudhan R, Madhu 0 Reputation points

2024-03-11T07:13:33.35+00:00

Hi @GeethaThatipatri-MSFT

I am also able to create trigger but unable to use the functionality of the trigger. As per the example which i shared the data in second table is not getting affected with any change in first table.

Regards

Madhu
GeethaThatipatri-MSFT 27,567 Reputation points Microsoft Employee

2024-03-12T19:37:13.94+00:00

@Sudhan R, Madhu Can you share some screenshot of the error message to understand better.

Regards

Geetha
Sudhan R, Madhu 0 Reputation points

2024-03-15T04:55:03.12+00:00

Hi @GeethaThatipatri-MSFT

I am not getting any error while calling the trigger function.

Regards

Madhu
Sudhan R, Madhu 0 Reputation points

2024-03-18T05:19:53.8466667+00:00

Hi @GeethaThatipatri-MSFT

I am not getting any error while running the trigger functionality.