Hi Jeremy,
Could you apply something similar using triggers?
One question would be how PG would identify changes to existing rows - using the replication facilities to essentially
replicateinto the view? This would be quite tricky I reckon. Otherwise a change to the underlying table may not
propagatecorrectly to the MV.
--
Jordan Deitch
https://id.rsa.pub/