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 <ddevienne@gmail.com>) |
Ответы |
Re: DISABLE TRIGGER doc wrong?
|
Список | pgsql-general |
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 по дате отправления: