Thread

1. Re: Materialized views WIP patch

   Kevin Grittner <kgrittn@mail.com> — 2013-01-16T13:27:31Z

   [resending with patch compressed, since original post didn't make
   it through to the list]
   
   Here is a new version of the patch, with most issues discussed in
   previous posts fixed.
   
   I've been struggling with two areas:
   
    - pg_dump sorting for MVs which depend on other MVs
    - proper handling of the relisvalid flag for unlogged MVs after recovery
   
   I've been hacking at the code in those areas without success;
   what's here is the least broken form I have, but work is still
   needed for these cases. Any other problems are news to me.
   
   In addition, the docs need another pass, and there is an open
   question about what is the right thing to use for TRUNCATE syntax.
   
   -Kevin
   

2. Re: Materialized views WIP patch

   Tom Lane <tgl@sss.pgh.pa.us> — 2013-01-16T16:26:51Z

   "Kevin Grittner" <kgrittn@mail.com> writes:
   > I've been struggling with two areas:
   >  - pg_dump sorting for MVs which depend on other MVs
   
   Surely that should fall out automatically given that the dependency is
   properly expressed in pg_depend?
   
   If you mean you're trying to get it to cope with circular dependencies
   between MVs, it might take some work on the pg_dump side, but plain
   ordering shouldn't require new code.
   
   			regards, tom lane