aboutsummaryrefslogtreecommitdiffstats
path: root/sql/postgres/patch-querycache_info-pk.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/postgres/patch-querycache_info-pk.sql')
-rw-r--r--sql/postgres/patch-querycache_info-pk.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/postgres/patch-querycache_info-pk.sql b/sql/postgres/patch-querycache_info-pk.sql
new file mode 100644
index 000000000000..4247a09d3b7a
--- /dev/null
+++ b/sql/postgres/patch-querycache_info-pk.sql
@@ -0,0 +1,3 @@
+ALTER TABLE querycache_info
+ DROP CONSTRAINT querycache_info_qci_type_key,
+ ADD PRIMARY KEY (qci_type);