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

Поиск
Список
Период
Сортировка
От Andre Lopes
Тема How to correct: ERROR: permission denied: "RI_ConstraintTrigger_24966" is a system trigger
Дата
Msg-id CAGFRAbNy_CoxEBXEcbBqJ0rPdgBajYGPhkxO1UOZh6TnQj=8PQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to correct: ERROR: permission denied: "RI_ConstraintTrigger_24966" is a system trigger
Список 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,

В списке pgsql-general по дате отправления:

Предыдущее
От: Mark Priest
Дата:
Сообщение: Out of Memory Error on Insert
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Out of Memory Error on Insert