Where is it documented what role executes constraint triggers?

From: Chapman Flack <chap(at)anastigmatix(dot)net>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Where is it documented what role executes constraint triggers?
Date: 2017-11-03 18:09:00
Message-ID: 0b7c00ac-deb6-826d-e17d-7faf69830025@anastigmatix.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

From a little experimenting in 9.5, it seems that a referential
integrity trigger is executed with the identity of the referencED
table's owner, but I have not been able to find this covered in
the docs. Is this a documentation oversight, or is it explained
somewhere I didn't look (or may have skimmed right over it)?

The question came up at $work after the departure of $colleague,
who had created some tables as himself and not changed their
ownership. His role had the superuser bit at the time, so
RI checks involving those tables never incurred 'permission denied'
errors until he left. Then, his role was not dropped, only disabled
for login and made no longer superuser, and that's when RI checks
started incurring 'permission denied'.

-Chap

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nico Williams 2017-11-03 18:11:58 Re: Where is it documented what role executes constraint triggers?
Previous Message Nico Williams 2017-11-03 17:56:28 Re: [PATCH] Add ALWAYS DEFERRED option for constraints