> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers