Re: [HACKERS] Where is it documented what role executes constraint triggers?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Where is it documented what role executes constraint triggers?
Дата
Msg-id 5761.1509733215@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [HACKERS] Where is it documented what role executes constraint triggers?  (Chapman Flack <chap@anastigmatix.net>)
Список pgsql-hackers
Chapman Flack <chap@anastigmatix.net> writes:
> 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)?

Don't know if it's documented anywhere user-facing, but a look into
the code in ri_triggers.c says we run RI queries as the owner of
whichever table the query touches (the referenced table for verification
of FK inserts, the referencing table when cascading a PK change).
        regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Nico Williams
Дата:
Сообщение: Re: [HACKERS] Where is it documented what role executes constrainttriggers?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Proposal: Local indexes for partitioned table