>>>> 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.
Thanks. I will look into it. Pgpool-II has its own password file which needs to be sync with the md5 hashed password of PostgreSQL. So I thought it would be nice if the event trigger could be used for the purpose. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers