postgresql 触发器不适用于特定表postgres 11

b0zn9rqh  于 2023-03-01  发布在  PostgreSQL
关注(0)|答案(1)|浏览(116)
: 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();

触发器已创建,但不起作用。创建时的消息。

bjp0bcyl

bjp0bcyl1#

问题是它是一个分区表,事实上,那里什么也没有写。

相关问题