Quick Links

Re: Event trigger and CREATE/ALTER ROLE/USER

From:	Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To:	Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Cc:	pgsql-hackers(at)postgresql(dot)org
Subject:	Re: Event trigger and CREATE/ALTER ROLE/USER
Date:	2016-09-14 01:42:47
Message-ID:	20160914014247.GA440644@alvherre.pgsql
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

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

In response to

Event trigger and CREATE/ALTER ROLE/USER at 2016-09-14 00:26:12 from Tatsuo Ishii

Responses

Re: Event trigger and CREATE/ALTER ROLE/USER at 2016-09-14 01:48:46 from Craig Ringer
Re: Event trigger and CREATE/ALTER ROLE/USER at 2016-09-14 02:09:57 from Tatsuo Ishii

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Craig Ringer	2016-09-14 01:48:46	Re: Event trigger and CREATE/ALTER ROLE/USER
Previous Message	Masahiko Sawada	2016-09-14 01:10:22	Re: DISABLE_PAGE_SKIPPING option for vacuumdb