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@xxxxxxxxxxx
