8000 test_ddl_deparse: Don't use pg_class as source for a matview · divag711/postgres@91797fa · GitHub
[go: up one dir, main page]
Skip to content

Commit 91797fa

Browse files
alvherrealvherre
committed
test_ddl_deparse: Don't use pg_class as source for a matview
Doing so causes a pg_upgrade of a database containing these objects to fail whenever pg_class changes. And it's pointless anyway: we have more interesting tables anyhow. Discussion: https://postgr.es/m/CAD5tBc+s8pW9WvH2+_z=B4x95FD4QuzZKcaMpff_9H4rS0VU1A@mail.gmail.com
1 parent 8e3f3ab commit 91797fa

File tree

2 files changed

+2
-2
lines changed

2 files changed

+2
-2
lines changed

‎src/test/modules/test_ddl_deparse/expected/matviews.out

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
-- Materialized views
33
--
44
CREATE MATERIALIZED VIEW pg_class_mv AS
5-
SELECT * FROM pg_class LIMIT 1 WITH NO DATA;
5+
SELECT * FROM datatype_table LIMIT 1 WITH NO DATA;
66
NOTICE: DDL test: type simple, tag CREATE MATERIALIZED VIEW
77
REFRESH MATERIALIZED VIEW pg_class_mv;
88
NOTICE: DDL test: type simple, tag REFRESH MATERIALIZED VIEW

‎src/test/modules/test_ddl_deparse/sql/matviews.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,6 +3,6 @@
33
--
44

55
CREATE MATERIALIZED VIEW pg_class_mv AS
6-
SELECT * FROM pg_class LIMIT 1 WITH NO DATA;
6+
SELECT * FROM datatype_table LIMIT 1 WITH NO DATA;
77

88
REFRESH MATERIALIZED VIEW pg_class_mv;

0 commit comments

Comments
 (0)
0