diff options
author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-03-15 09:51:12 -0300 |
---|---|---|
committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-03-15 09:51:12 -0300 |
commit | e69f5e0efcaf3f26381e56a1507cdf401bf1bdfd (patch) | |
tree | e2301a5a9a509e419c5e9f2ac5834d4ce736c2b4 | |
parent | 24c0a6c649768f428929e76dd7f5012ec9b93ce1 (diff) | |
download | postgresql-e69f5e0efcaf3f26381e56a1507cdf401bf1bdfd.tar.gz postgresql-e69f5e0efcaf3f26381e56a1507cdf401bf1bdfd.zip |
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
-rw-r--r-- | src/test/modules/test_ddl_deparse/expected/matviews.out | 2 | ||||
-rw-r--r-- | src/test/modules/test_ddl_deparse/sql/matviews.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/modules/test_ddl_deparse/expected/matviews.out b/src/test/modules/test_ddl_deparse/expected/matviews.out index b946ff06d26..4ac2cc83253 100644 --- a/src/test/modules/test_ddl_deparse/expected/matviews.out +++ b/src/test/modules/test_ddl_deparse/expected/matviews.out @@ -2,7 +2,7 @@ -- Materialized views -- CREATE MATERIALIZED VIEW pg_class_mv AS - SELECT * FROM pg_class LIMIT 1 WITH NO DATA; + SELECT * FROM datatype_table LIMIT 1 WITH NO DATA; NOTICE: DDL test: type simple, tag CREATE MATERIALIZED VIEW REFRESH MATERIALIZED VIEW pg_class_mv; NOTICE: DDL test: type simple, tag REFRESH MATERIALIZED VIEW diff --git a/src/test/modules/test_ddl_deparse/sql/matviews.sql b/src/test/modules/test_ddl_deparse/sql/matviews.sql index 381c11e1f84..990082934e3 100644 --- a/src/test/modules/test_ddl_deparse/sql/matviews.sql +++ b/src/test/modules/test_ddl_deparse/sql/matviews.sql @@ -3,6 +3,6 @@ -- CREATE MATERIALIZED VIEW pg_class_mv AS - SELECT * FROM pg_class LIMIT 1 WITH NO DATA; + SELECT * FROM datatype_table LIMIT 1 WITH NO DATA; REFRESH MATERIALIZED VIEW pg_class_mv; |