> As expected, the refresh failed, but the error message is not really
> user-friendly.
> Shouldn't we output instead something like that?
> ERROR: could not refresh materialized view because of failure when
> rebuilding index"
> DETAIL: key is duplicated.
Is there a good reason to allow unique indexes (or constraints in
general) on matviews?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com