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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
