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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
