Commita2102e1

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 tofail whenever pg_class changes. And it's pointless anyway: we have moreinteresting tables anyhow.Discussion:https://postgr.es/m/CAD5tBc+s8pW9WvH2+_z=B4x95FD4QuzZKcaMpff_9H4rS0VU1A@mail.gmail.com

1 parent3c3450e commita2102e1Copy full SHA for a2102e1

File tree

-2

lines changed

src/test/modules/test_ddl_deparse
- expected
  - matviews.out
- sql
  - matviews.sql

-2

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2,7 +2,7 @@`
`2`	`2`	`-- Materialized views`
`3`	`3`	`--`
`4`	`4`	`CREATE MATERIALIZED VIEW pg_class_mv AS`
`5`		`- SELECT * FROMpg_class LIMIT 1 WITH NO DATA;`
	`5`	`+ SELECT * FROMdatatype_table LIMIT 1 WITH NO DATA;`
`6`	`6`	`NOTICE: DDL test: type simple, tag CREATE MATERIALIZED VIEW`
`7`	`7`	`REFRESH MATERIALIZED VIEW pg_class_mv;`
`8`	`8`	`NOTICE: DDL test: type simple, tag REFRESH MATERIALIZED VIEW`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -3,6 +3,6 @@`
`3`	`3`	`--`
`4`	`4`
`5`	`5`	`CREATE MATERIALIZED VIEW pg_class_mvAS`
`6`		`-SELECT*FROMpg_classLIMIT1 WITH NO DATA;`
	`6`	`+SELECT*FROMdatatype_tableLIMIT1 WITH NO DATA;`
`7`	`7`
`8`	`8`	`REFRESH MATERIALIZED VIEW pg_class_mv;`

Comments

(0)