Kevin, > I'm looking at whether there is some reasonable way to detect invalid > data as well as capture age of data. Every solution I've thought of > so far has at least one hard-to-solve race condition, but I have > hopes that I can either solve that for one of the ideas, or come up > with an idea which falls more gracefully under MVCC management.
What's the race condition? I'd think that LOAD would take an exclusive lock on the matview involved. > LOAD MATERIALIZED VIEW matview_name; > > to be very easy to confuse with > > LOAD 'filename'; > > But that's a subjective thing. If too many people find that > confusing, it may be worth creating a new keyword; but I wanted to > see whether it was really necessary first. I do not find them confusing. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers