Hi,
Please find the attached patch to fix RM #2949 : [Web Based] Complete sql
should displayed for fts directory in sql pane.
Thanks,
Khushboo
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/__init__.py b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/__init__.py
index 658a7bf..6b1d348 100644
--- a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/__init__.py
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/__init__.py
@@ -799,6 +799,14 @@ class FtsDictionaryView(PGChildNodeView):
data=res['rows'][0],
conn=self.conn, is_displaying=True)
+ sql_header = u"""-- Text Search Dictionary: {0}
+
+-- DROP TEXT SEARCH DICTIONARY {0};
+
+""".format(self.qtIdent(self.conn, res['rows'][0]['schema'], res['rows'][0]['name']))
+
+ sql = sql_header + sql
+
return ajax_response(response=sql.strip('\n'))
@check_precondition