Re: How to correct: ERROR: permission denied: "RI_ConstraintTrigger_24966" is a system trigger

On Tuesday, October 18, 2011 2:42:00 am Andre Lopes wrote:
> Hi,
>
> I have created a database and all tables with a user, but I can't
> execute this alter table:
>
> [code]
> xxx_database=> ALTER TABLE tdir_categories DISABLE TRIGGER ALL;
> ERROR: permission denied: "RI_ConstraintTrigger_25366" is a system trigger
> [/code]
>
> What can I do to solve this?

As pointed out below, you need to be a superuser. You can check the the
superuser status of users by doing \du at the psql command line and looking in
the attributes column.

>
> Best Regards,
>

> > You're trying to disable triggers associated with foreign key constraints
> > or CHECK constraints, too. You should probably skip those system
> > triggers in your function.
> >
> > If you want to disable them too, I think you have to be the table owner,
> > or maybe superuser; I don't remember and haven tested. In any case, the
> > user you're running as doesn't have permission to disable those.
> >
> > --
> > Craig Ringer

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com