Re: postgres event trigger workaround

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: postgres event trigger workaround
Дата
Msg-id 20220112125517.idglbczyiargb56f@jrouhaud
обсуждение исходный текст
Ответ на postgres event trigger workaround  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
Ответы AW: [Extern] Re: postgres event trigger workaround
Список pgsql-general
Hi,

On Wed, Jan 12, 2022 at 11:57:45AM +0000, Zwettler Markus (OIZ) wrote:
> 
> PG event triggers are not firing on CREATE ROLE, CREATE DATABASE, CREATE
> TABLESPACE by definition (would be nice if they do).
> 
> Is there any workaround to react with ddl_command_start behavior on such an
> event?

That's not possible.  The limitation exists because those objects are shared
objects and therefore could be created from any database in the cluster.

What is your use case?  Maybe you could rely on logging all DDL instead for
instance.



В списке pgsql-general по дате отправления:

Предыдущее
От: Issa Gorissen
Дата:
Сообщение: WAL Archiving and base backup
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: pg_stat_statements