postgres.git / summary / log / commit / refs

commit    a2102e1a92bf0b485487b0582f2efaa9ff025556
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Thu Mar 15 12:51:12 2018 +0000
First released in: 11.0, 9.5.13, 9.6.9, 10.4

    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


src/test/modules/test_ddl_deparse/expected/matviews.out | 2 +- 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; [parent: 3c3450e74ff8]