On Wed, Sep 14, 2016 at 9:34 AM, Tatsuo Ishii <[email protected]> wrote: >>> Simple question: Is there any reason for event trigger to not support >>> CREATE/ALTER ROLE/USER? >> >> Because it performs a global administrative task, no? > > So is there any technical difficulty?
I don't recall the exact details but... > Can you please elaborate? Roles are global objects, and event triggers cannot operate on such ones. See for example 296f3a60 mentioning for example why REVOKE/GRANT can only operate on local objects. -- Michael -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
