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

From: Andre Lopes <lopes80andre(at)gmail(dot)com>
To: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: How to correct: ERROR: permission denied: "RI_ConstraintTrigger_24966" is a system trigger
Date: 2011-10-18 07:52:53
Message-ID: CAGFRAbNy_CoxEBXEcbBqJ0rPdgBajYGPhkxO1UOZh6TnQj=8PQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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]

This is known problem? How to solve this?

Best Regards,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-10-18 07:56:12 Re: Out of Memory Error on Insert
Previous Message Mark Priest 2011-10-18 06:52:41 Out of Memory Error on Insert