django.db.utils.ProgrammingError：权限被拒绝：“ RI_ConstraintTrigger_a_25437”；是系统触发器 [英] django.db.utils.ProgrammingError: permission denied: "RI_ConstraintTrigger_a_25437" is a system trigger

问题描述

我正在尝试使用以下代码为我的PostgreSQL表之一禁用触发器

I am trying to disable the triggers for one of my PostgreSQL table using the following code

def disable_triggers(self):
    with connection.cursor() as cursor:
        cursor.execute('ALTER TABLE "frontend_awsregions" DISABLE TRIGGER ALL;')

但这给了我以下错误

...
..

返回self.cursor.execute（sql）
django.db.utils.ProgrammingError：权限被拒绝：
RI_ConstraintTrigger_a_25437是系统触发器

... ...
return self.cursor.execute(sql) django.db.utils.ProgrammingError: permission denied: "RI_ConstraintTrigger_a_25437" is a system trigger

当我在PGAdmin中执行相同查询时，它正常工作

when I execute the same query in PGAdmin, its working properly

推荐答案

我去打开了PgAdmin对当前数据库用户的超级用户权限。

I went and turned on the superuser permission from PgAdmin for the current DB user. and it fixed it for me.

这篇关于django.db.utils.ProgrammingError：权限被拒绝：“ RI_ConstraintTrigger_a_25437”；是系统触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！