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:57:04 -0300 |
| commit | 91797fa43817b1a29bf783df7479915e89770fe6 (patch) | |
| tree | 726ec6c00c079b4247e8571b83a7e0ffd5448508 /src | |
| parent | 8e3f3ab5b85a230e9a008c743402c3e5a43085a1 (diff) | |
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
Diffstat (limited to 'src')
| -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; |