aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/sql/temp.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/temp.sql')
-rw-r--r--src/test/regress/sql/temp.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/src/test/regress/sql/temp.sql b/src/test/regress/sql/temp.sql
index 424d12b2833..2a487a1ef7f 100644
--- a/src/test/regress/sql/temp.sql
+++ b/src/test/regress/sql/temp.sql
@@ -101,6 +101,22 @@ COMMIT;
SELECT * FROM temptest;
+-- Test it with a CHECK condition that produces a toasted pg_constraint entry
+BEGIN;
+do $$
+begin
+ execute format($cmd$
+ CREATE TEMP TABLE temptest (col text CHECK (col < %L)) ON COMMIT DROP
+ $cmd$,
+ (SELECT string_agg(g.i::text || ':' || random()::text, '|')
+ FROM generate_series(1, 100) g(i)));
+end$$;
+
+SELECT * FROM temptest;
+COMMIT;
+
+SELECT * FROM temptest;
+
-- ON COMMIT is only allowed for TEMP
CREATE TABLE temptest(col int) ON COMMIT DELETE ROWS;