Re: [HACKERS] Event trigger and CREATE/ALTER ROLE/USER

2016-09-18 Thread Michael Paquier
On Wed, Sep 14, 2016 at 11:09 AM, Tatsuo Ishii wrote: >> 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 fun

Re: [HACKERS] Event trigger and CREATE/ALTER ROLE/USER

2016-09-13 Thread Tatsuo Ishii
> 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

Re: [HACKERS] Event trigger and CREATE/ALTER ROLE/USER

2016-09-13 Thread Craig Ringer
On 14 Sep. 2016 9:44 am, "Alvaro Herrera" wrote: > > 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 dat

Re: [HACKERS] Event trigger and CREATE/ALTER ROLE/USER

2016-09-13 Thread Alvaro Herrera
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

Re: [HACKERS] Event trigger and CREATE/ALTER ROLE/USER

2016-09-13 Thread Tatsuo Ishii
Simple question: Is there any reason for event trigger to not support CREATE/ALTER ROLE/USER? >>> >>> Because it performs a global administrative task, no? >> >> So is there any technical difficulty? > > I don't recall the exact details but... > >> Can you please elaborate? > > Roles a

Re: [HACKERS] Event trigger and CREATE/ALTER ROLE/USER

2016-09-13 Thread Michael Paquier
On Wed, Sep 14, 2016 at 9:34 AM, Tatsuo Ishii wrote: >>> Simple question: Is there any reason for event trigger to not support >>> CREATE/ALTER ROLE/USER? >> >> Because it performs a global administrative task, no? > > So is there any technical difficulty? I don't recall the exact details but...

Re: [HACKERS] Event trigger and CREATE/ALTER ROLE/USER

2016-09-13 Thread Tatsuo Ishii
>> Simple question: Is there any reason for event trigger to not support >> CREATE/ALTER ROLE/USER? > > Because it performs a global administrative task, no? So is there any technical difficulty? Can you please elaborate? Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.srao

Re: [HACKERS] Event trigger and CREATE/ALTER ROLE/USER

2016-09-13 Thread Michael Paquier
On Wed, Sep 14, 2016 at 9:26 AM, Tatsuo Ishii wrote: > Simple question: Is there any reason for event trigger to not support > CREATE/ALTER ROLE/USER? Because it performs a global administrative task, no? -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

[HACKERS] Event trigger and CREATE/ALTER ROLE/USER

2016-09-13 Thread Tatsuo Ishii
Simple question: Is there any reason for event trigger to not support CREATE/ALTER ROLE/USER? Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To