Postgres Pro
Downloads
Home   >   mailing lists

Re: Event trigger and CREATE/ALTER ROLE/USER - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Event trigger and CREATE/ALTER ROLE/USER
Date
Msg-id 20160914014247.GA440644@alvherre.pgsql
Whole thread Raw
In response to Event trigger and CREATE/ALTER ROLE/USER  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: Event trigger and CREATE/ALTER ROLE/USER  (Craig Ringer <craig.ringer@2ndquadrant.com>)
Re: Event trigger and CREATE/ALTER ROLE/USER  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
Tree view 
Tatsuo Ishii wrote:
> Simple question: Is there any reason for event trigger to not support
> CREATE/ALTER ROLE/USER?

As I understand the issue, the main reason is that event triggers
execute procedures, and those exist in a single database only.  If you
were to create an event trigger in database A, then a user gets created
in database B, your function would not be invoked, which becomes a
problem.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: DISABLE_PAGE_SKIPPING option for vacuumdb
Next
From: Craig Ringer
Date:
Subject: Re: Event trigger and CREATE/ALTER ROLE/USER