Trigger (or something similar) on table rename?
От | Ken Tanzer |
---|---|
Тема | Trigger (or something similar) on table rename? |
Дата | |
Msg-id | CAD3a31X1VJgH1zE5GuVL0Ws03y7UEHe5mQxar5gv0n3gCJ=Wng@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Trigger (or something similar) on table rename?
Re: Trigger (or something similar) on table rename? Re: Trigger (or something similar) on table rename? |
Список | pgsql-general |
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
(253) 245-3801
learn more about AGENCY or
follow the discussion.
В списке pgsql-general по дате отправления: