Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit e69f5e0

Browse filesBrowse files
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 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
1 parent 24c0a6c commit e69f5e0
Copy full SHA for e69f5e0

File tree

Expand file treeCollapse file tree

2 files changed

+2
-2
lines changed
Filter options
Expand file treeCollapse file tree

2 files changed

+2
-2
lines changed

‎src/test/modules/test_ddl_deparse/expected/matviews.out

Copy file name to clipboardExpand all lines: src/test/modules/test_ddl_deparse/expected/matviews.out
+1-1Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
-- Materialized views
33
--
44
CREATE MATERIALIZED VIEW pg_class_mv AS
5-
SELECT * FROM pg_class LIMIT 1 WITH NO DATA;
5+
SELECT * FROM datatype_table LIMIT 1 WITH NO DATA;
66
NOTICE: DDL test: type simple, tag CREATE MATERIALIZED VIEW
77
REFRESH MATERIALIZED VIEW pg_class_mv;
88
NOTICE: DDL test: type simple, tag REFRESH MATERIALIZED VIEW

‎src/test/modules/test_ddl_deparse/sql/matviews.sql

Copy file name to clipboardExpand all lines: src/test/modules/test_ddl_deparse/sql/matviews.sql
+1-1Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,6 +3,6 @@
33
--
44

55
CREATE MATERIALIZED VIEW pg_class_mv AS
6-
SELECT * FROM pg_class LIMIT 1 WITH NO DATA;
6+
SELECT * FROM datatype_table LIMIT 1 WITH NO DATA;
77

88
REFRESH MATERIALIZED VIEW pg_class_mv;

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.