On Wed, Sep 14, 2016 at 9:34 AM, Tatsuo Ishii <is...@sraoss.co.jp> 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 (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers