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:20 -0300 |
| commit | a2102e1a92bf0b485487b0582f2efaa9ff025556 (patch) | |
| tree | c72f0a24b3a87389461be76db9f03c5a70134822 /src | |
| parent | 3c3450e74ff8d0b7d4952003ad8c8ecab08a0ef8 (diff) | |
| download | postgresql-a2102e1a92bf0b485487b0582f2efaa9ff025556.tar.gz postgresql-a2102e1a92bf0b485487b0582f2efaa9ff025556.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
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; |