Maybe old eyes, but ... On Wed, Jun 20, 2018 at 7:03 PM, Melvin Davidson <melvin6925@gmail.com> wrote: >>Is there a way to be notified on the CREATE TABLE execution? > Here is sample code that will notify for a CREATE or DROP table:
Doesn't this trigger just log the events? I think it's missing something like "Notify create_or_drop" somewhere after the logging ( so a listener knows to look at the log table ).
( Normally I would use something like this, listen to a channel, do a first scan from the saved last tbl_cl_key, and then do another scan from the last each time listen fires, it seems the difficult work is done but it misses the notify to signal listeners and avoid having to rescan on a timer or a similar thing ).
( Maybe I missed the line, it would not be the first time, that's why I ask ). Francisco Olarte.
> Maybe old eyes, but ... >I think it's missing >something like "Notify create_or_drop" somewhere after the logging ( >so a listener knows to look at the log table ).
Uh, I said it was a SAMPLE. It's not that difficult to add RAISE INFO... or NOTIFY...
which, if you look, is commented out with generic information..
Of course, the exact message is left to the creator.
