D
D
des1roer2015-08-17 08:03:04
PostgreSQL
des1roer, 2015-08-17 08:03:04

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

1 answer(s)
S
sim3x, 2015-08-17
@sim3x

do it with an external script - a trigger is not the best solution for this kind of tasks

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question