Re: DISABLE TRIGGER doc wrong?

Поиск
Список
Период
Сортировка
Искать
От
Adrian Klaver
Тема
Re: DISABLE TRIGGER doc wrong?
Дата
Msg-id
3a6e840a-5c30-4eed-9e5b-474dafc6c29f@aklaver.com
Ответ на
DISABLE TRIGGER doc wrong? (Dominique Devienne)
Список
Дерево обсуждения
DISABLE TRIGGER doc wrong? Dominique Devienne <ddevienne@gmail.com>
Re: DISABLE TRIGGER doc wrong? Pavel Luzanov <p.luzanov@postgrespro.ru>
Re: DISABLE TRIGGER doc wrong? Dominique Devienne <ddevienne@gmail.com>
Re: DISABLE TRIGGER doc wrong? Adrian Klaver <adrian.klaver@aklaver.com>
Re: DISABLE TRIGGER doc wrong? Dominique Devienne <ddevienne@gmail.com>
Re: DISABLE TRIGGER doc wrong? Ron Johnson <ronljohnsonjr@gmail.com>
Re: DISABLE TRIGGER doc wrong? Dominique Devienne <ddevienne@gmail.com>
Re: DISABLE TRIGGER doc wrong? Ron Johnson <ronljohnsonjr@gmail.com>
Re: DISABLE TRIGGER doc wrong? Tom Lane <tgl@sss.pgh.pa.us>
Re: DISABLE TRIGGER doc wrong? Adrian Klaver <adrian.klaver@aklaver.com>
Re: DISABLE TRIGGER doc wrong? Dominique Devienne <ddevienne@gmail.com>
Re: DISABLE TRIGGER doc wrong? Dominique Devienne <ddevienne@gmail.com>
On 8/25/25 09:19, Dominique Devienne wrote:
> or I'm reading it wrong? --DD
> 
>  From https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-DESC-DISABLE-ENABLE-TRIGGER:
>> Disabling or enabling internally generated constraint triggers requires superuser privileges
> 
> We were disabling triggers as the owner of the table just fine, no
> SUPERUSER involved. So is the doc out-of-date?

 From the sentence before the above:

"... internally generated constraint triggers, such as those that are 
used to implement foreign key constraints or deferrable uniqueness and 
exclusion constraints)."

> 
> PS: By mistake... We were ALTER TABLE {}.{} DISABLE TRIGGER ALL
>    when we meant ALTER TABLE {}.{} DISABLE TRIGGER USER
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


В списке pgsql-general по дате отправления
От: Dominique Devienne
Дата:
Сообщение: DISABLE TRIGGER doc wrong?
От: Dominique Devienne
Дата:
Сообщение: Re: DISABLE TRIGGER doc wrong?
FAQ