summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/prepare.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/prepare.sql')
-rw-r--r--src/test/regress/sql/prepare.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/src/test/regress/sql/prepare.sql b/src/test/regress/sql/prepare.sql
index d42b7a0879..c7b5b13634 100644
--- a/src/test/regress/sql/prepare.sql
+++ b/src/test/regress/sql/prepare.sql
@@ -68,3 +68,9 @@ PREPARE q7(unknown) AS
SELECT name, statement, parameter_types FROM pg_prepared_statements
ORDER BY name;
+
+-- test DEALLOCATE ALL;
+DEALLOCATE ALL;
+SELECT name, statement, parameter_types FROM pg_prepared_statements
+ ORDER BY name;
+