开发者

postgresql trigger when user group is changed?

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜