Hello,
This is a response to a rather old message 'automatically refresh all materialized views?' linked below. I just implemented a recursive refresh for my own purposes, as I couldn't find an existing implementation. I've put it as a gist on github in case anyone else runs into the same problem.
Original question: https://www.postgresql.org/message-id/CAKNDN-db%2BC%3DyW9UwoqF8NBrPbeJLLXrSDvqa6MyDwpLvQBqfSA%40mail.gmail.com
This is a response to a rather old message 'automatically refresh all materialized views?' linked below. I just implemented a recursive refresh for my own purposes, as I couldn't find an existing implementation. I've put it as a gist on github in case anyone else runs into the same problem.
Original question: https://www.postgresql.org/message-id/CAKNDN-db%2BC%3DyW9UwoqF8NBrPbeJLLXrSDvqa6MyDwpLvQBqfSA%40mail.gmail.com
Note: I don't deal with the circular references that the original discussion dwelt on. :-)
Regards, Bit.