On 10/18/2011 03:52 PM, Andre Lopes wrote:
Hi, I have created a database that have a function that disable triggers on tables, but when I execute the function: (I have created the database with the same user that I'm trying to execute the function) [code] select triggerall(false); [/code] return [code] ERROR: permission denied: "RI_ConstraintTrigger_24966" is a system trigger CONTEXT: SQL statement "ALTER TABLE tdir_languages DISABLE TRIGGER ALL" PL/pgSQL function "triggerall" line 14 at EXECUTE statement [/code]
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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
