Hi, PFA the patch for minor typo issue in fts dictionary node. Please do review it and commit if found proper.
Regards, Sanket Mehta Sr Software engineer Enterprisedb
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/templates/fts_dictionary/sql/9.1_plus/nodes.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/templates/fts_dictionary/sql/9.1_plus/nodes.sql index 78abd0b..272c23c 100644 --- a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/templates/fts_dictionary/sql/9.1_plus/nodes.sql +++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/templates/fts_dictionary/sql/9.1_plus/nodes.sql @@ -1,4 +1,4 @@ -{# FETCH FTS DICTIONARY name statement #} +{# FETCH FTS DICTIONARY NAME statement #} SELECT oid, dictname as name FROM @@ -7,7 +7,7 @@ WHERE {% if scid %} dict.dictnamespace = {{scid}}::OID {% elif dcid %} - dict.oid = {{pid}}::OID + dict.oid = {{dcid}}::OID {% endif %} ORDER BY name \ No newline at end of file diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/templates/fts_dictionary/sql/9.1_plus/sql.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/templates/fts_dictionary/sql/9.1_plus/sql.sql index 42537f6..6a36829 100644 --- a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/templates/fts_dictionary/sql/9.1_plus/sql.sql +++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/templates/fts_dictionary/sql/9.1_plus/sql.sql @@ -16,7 +16,7 @@ FROM E'\n);' || CASE WHEN description IS NOT NULL THEN - E'\n\nCOMMENT ON TEXT SEARCH TEMPLATE ' || nspname || E'.' || dict.dictname || + E'\n\nCOMMENT ON TEXT SEARCH DICTIONARY ' || nspname || E'.' || dict.dictname || E' IS ' || pg_catalog.quote_literal(description) || E';' ELSE '' END as sql FROM
-- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers