Answer the question
In order to leave comments, you need to log in
How to check triggers in Postgres?
the situation is as follows - made partitioning by months. Everything seemed to be fine until X-hour. but after a crash the triggers stopped working. triggers are added automatically when creating a partition. They are named the same, but it seems to be normal. an elementary trigger - check the entry of data by id, check the time difference, and enter a new element. data is written continuously. So before the reboot everything was ok (this month), but now it's not. what should I watch? check if the function works? test trigger and see what it does? what can be seen in the logs? Basically, how do you know what's going on?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question