summaryrefslogtreecommitdiff
path: root/src/test/regress/expected/with.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/expected/with.out')
-rw-r--r--src/test/regress/expected/with.out3
1 files changed, 3 insertions, 0 deletions
diff --git a/src/test/regress/expected/with.out b/src/test/regress/expected/with.out
index 3b7f689a98..fdcc4970a1 100644
--- a/src/test/regress/expected/with.out
+++ b/src/test/regress/expected/with.out
@@ -2272,3 +2272,6 @@ with ordinality as (select 1 as x) select * from ordinality;
1
(1 row)
+-- check sane response to attempt to modify CTE relation
+WITH d AS (SELECT 42) INSERT INTO d VALUES (1);
+ERROR: relation "d" cannot be the target of a modifying statement