diff options
Diffstat (limited to 'src/test/regress/expected/plancache.out')
| -rw-r--r-- | src/test/regress/expected/plancache.out | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/src/test/regress/expected/plancache.out b/src/test/regress/expected/plancache.out index c0681d26e3..853ae94fdb 100644 --- a/src/test/regress/expected/plancache.out +++ b/src/test/regress/expected/plancache.out @@ -79,6 +79,7 @@ EXECUTE prepstmt2(123); -- but should trigger invalidation anyway CREATE TEMP VIEW pcacheview AS SELECT * FROM pcachetest; +NOTICE: CREATE VIEW has created automatic view update rules PREPARE vprep AS SELECT * FROM pcacheview; EXECUTE vprep; q1 | q2 @@ -236,6 +237,9 @@ select cachebug(); NOTICE: table "temptable" does not exist, skipping CONTEXT: SQL statement "drop table if exists temptable cascade" PL/pgSQL function "cachebug" line 3 at SQL statement +NOTICE: CREATE VIEW has created automatic view update rules +CONTEXT: SQL statement "create temp view vv as select * from temptable" +PL/pgSQL function "cachebug" line 5 at SQL statement NOTICE: 1 NOTICE: 2 NOTICE: 3 @@ -248,6 +252,9 @@ select cachebug(); NOTICE: drop cascades to view vv CONTEXT: SQL statement "drop table if exists temptable cascade" PL/pgSQL function "cachebug" line 3 at SQL statement +NOTICE: CREATE VIEW has created automatic view update rules +CONTEXT: SQL statement "create temp view vv as select * from temptable" +PL/pgSQL function "cachebug" line 5 at SQL statement NOTICE: 1 NOTICE: 2 NOTICE: 3 |