Postgres Pro
Downloads
Home   >   mailing lists

Re: missing event trigger support functions in 9.3 - Mailing list pgsql-hackers

From Misa Simic
Subject Re: missing event trigger support functions in 9.3
Date
Msg-id CAH3i69kGJEv69UQ=QoD8USRk4mKsmDYHosdMJxB0AoggY7gQig@mail.gmail.com
Whole thread Raw
In response to missing event trigger support functions in 9.3  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view
2013/5/9 Pavel Stehule <pavel.stehule@gmail.com>
Hello

I am writing a article about 9.3. I found so event trigger functions is not complete. We have only pg_event_trigger_dropped_objects() function. It looks really strange and asymmetric. Can we implement similar function for CREATE as minimum to 9.3?

I am expecting so this function should not be too complex - and can be moved to contrib maybe (if it is too late now).

Regards

Pavel


Maybe as workaround can help:

CREATE OR REPLACE FUNCTION snitch() RETURNS event_trigger AS $$
DECLARE
my_cmd text;
BEGIN
    SELECT query FROM pg_stat_activity where pid = pg_backend_pid() INTO my_cmd;
    RAISE NOTICE 'snitch: % % %', tg_event, tg_tag, my_cmd;
END;
$$ LANGUAGE plpgsql;
 
CREATE EVENT TRIGGER snitch ON ddl_command_start EXECUTE PROCEDURE snitch();

Then based on tg_tag - you can have different rules to take object_name from my_cmd - or whatever else is needed for additional rules...

Kind Regards,

Misa

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: missing event trigger support functions in 9.3
Next
From: Darren Duncan
Date:
Subject: Re: missing event trigger support functions in 9.3