DISABLE TRIGGER doc wrong?
От
Dominique Devienne
Тема
DISABLE TRIGGER doc wrong?
Дата
Msg-id
CAFCRh--VRAHh2D7PsvW1mgRFfx2bqLQH_8asEBTLBn3RDLT7tA@mail.gmail.com
Список
Дерево обсуждения
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>
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?
PS: By mistake... We were ALTER TABLE {}.{} DISABLE TRIGGER ALL
when we meant ALTER TABLE {}.{} DISABLE TRIGGER USER
В списке pgsql-general по дате отправления
От: Achilleas Mantzios
Дата:
