diff -U3 /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out /Users/admin/pgsql/build/testrun/regress/regress/results/incremental_matview.out --- /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out 2024-04-12 20:53:08 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/incremental_matview.out 2024-04-12 20:55:46 @@ -666,24 +666,14 @@ CREATE TABLE base_t (i int, v int); INSERT INTO base_t VALUES (1,10),(2, NULL); CREATE INCREMENTAL MATERIALIZED VIEW mv AS SELECT * FROM base_t; -NOTICE: could not create an index on materialized view "mv" automatically -DETAIL: This target list does not have all the primary key columns, or this view does not contain GROUP BY or DISTINCT clause. -HINT: Create an index on the materialized view for efficient incremental maintenance. +ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index" +DETAIL: Key (typname, typnamespace)=(mv, 2200) already exists. SELECT * FROM mv ORDER BY i; - i | v ----+---- - 1 | 10 - 2 | -(2 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block UPDATE base_t SET v = 20 WHERE i = 2; +ERROR: current transaction is aborted, commands ignored until end of transaction block SELECT * FROM mv ORDER BY i; - i | v ----+---- - 1 | 10 - 2 | 20 -(2 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK; BEGIN; CREATE TABLE base_t (i int);