: LOG: process 79596 still waiting for AccessExclusiveLock on relation 323059106 of database 16402 after 3005.513 ms
: DETAIL: Processes holding the lock: 83081, 83080, 83083, 83082, 62764, 37865, 39707. Wait queue: 79596, 95326.
: STATEMENT: -- Trigger: my_trigger
DROP TRIGGER my_trigger ON public.payments_log;
CREATE CONSTRAINT TRIGGER my_trigger
AFTER INSERT OR UPDATE ON payments_log
FOR EACH ROW
EXECUTE FUNCTION my_trigger_function();
触发器已创建,但不起作用。创建时的消息。
1条答案
按热度按时间bjp0bcyl1#
问题是它是一个分区表,事实上,那里什么也没有写。