Re: Event trigger and CREATE/ALTER ROLE/USER

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

> 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.

Can't we just create the event trigger in database B as well? We have
been living with similar situation, for example, functions for years.
(a work around would be creating functions in template1. This only
works for freshly created database though).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2016-09-14 02:43:15 Re: Hash Indexes
Previous Message Craig Ringer 2016-09-14 01:48:46 Re: Event trigger and CREATE/ALTER ROLE/USER