Hi. I'm wondering about possibilities for taking action when a table is renamed.
Specifically in this case, I'm using table_log, which when you use it on a table creates a new table, sequence and index that is tied to the table name. Of course, if the oriignal table is renamed, the other relations aren't. So I rename table to table_old, and then create a new version of table, but the table logging fails because of the already-existing relations that table_log created. I could of course rename them manually, or create a function to do it, but that would still need to be manually invoked. I haven't really used listen/notify--I assume it could do this, but there would need to be some kind of process actively listening? Something like a trigger on the table rename would be ideal for my purposes. Anything like that possible? Thanks! Ken -- AGENCY Software A Free Software data system By and for non-profits *http://agency-software.org/ <http://agency-software.org/>* *https://demo.agency-software.org/client <https://demo.agency-software.org/client>* ken.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.