开发者

postgresql trigger when user group is changed?

开发者 https://www.devze.com 2023-01-13 07:50 出处：网络

I would like to know if it is possible to have a trigger when a user is added to or drop from a group ? Does this trigger could also works when directly create a user in a group (create role ... in gr

相关专题：postgresql triggers usergroups

I would like to know if it is possible to have a trigger when a user is added to or drop from a group ? Does this trigger could also works when directly create a user in a group (create role ... in group ...) ?

(In fact, I want some users of a specified group to have a specific search_path, so I can set/reset the s开发者_如何学Pythonearch_path in the trigger).

No, PostgreSQL doesn't support DDL-triggers, only on INSERT, UPDATE, DELETE, or TRUNCATE events. Maybe in version 9.1, but that will be 2011 or even 2012 or later.

http://www.postgresql.org/docs/current/interactive/sql-createtrigger.html