CODEWITHSUNDEEP
postgresqltriggersusergroups
Philippe Gonday
Philippe Gonday

Reputation: 1766

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 search_path in the trigger).

Upvotes: 0

Views: 283

Answers (1)

Frank Heikens
Frank Heikens

Reputation: 127116

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

Upvotes: 2

Related Questions