Re: event triggers in 9.3.4 - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: event triggers in 9.3.4
Date
Msg-id CAKrjmheGtKQJ5tGPxj5i_y17bD0Xp6O_9yvuubBbCegsZMqnnQ@mail.gmail.com
Whole thread Raw
In response to Re: event triggers in 9.3.4  ("Vasudevan, Ramya" <ramya.vasudevan@classmates.com>)
Responses Re: event triggers in 9.3.4  ("Vasudevan, Ramya" <ramya.vasudevan@classmates.com>)
List pgsql-general
On Thu, Jul 24, 2014 at 7:13 PM, Vasudevan, Ramya <ramya.vasudevan@classmates.com> wrote:

>> You could compare list of tables before (_start) and after (_end) the ddl. Doing it in plpgsql will be tricky, but if you'd use some other language - like plperl - it's relatively simple:  http://www.depesz.com/2013/12/18/waiting-for-9-4-plperl-add-event-trigger-support/

Thank You Depesz.  This will work for ‘CREATE’ and ‘DROP’ DDLs.

 

But, what about the scenario where I want to just have event triggers for operations like these? - 'ALTER TABLE','ALTER TRIGGER', 'ALTER FUNCTION'


Sure - just check differences in appropriate catalogs. pg_attribute, pg_trigger, pg_proc.

In any way - if you want to really use it - you'll have to write in C.

depesz

pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: Re: Regular expression question with Postgres
Next
From: Rebecca Clarke
Date:
Subject: Re: Index usage with slow query