Text Search Configuration Mapping displayed out of order, pgAdmin 1.10.0 - Mailing list pgadmin-support
From | Jean-Pierre Pelletier |
---|---|
Subject | Text Search Configuration Mapping displayed out of order, pgAdmin 1.10.0 |
Date | |
Msg-id | 8A7EEE5FC42A49BFABE5D103F1ECA459@edjuster.network Whole thread Raw |
List | pgadmin-support |
Hi, We've noticed that pgAdmin displays the mapping of text search configurations out of order after using pg_dump & pg_restore with pgAdmin 1.10.0 against PostgreSQL 8.3.8 on Windows Server 2008 64 bits. Thanks, Jean-Pierre Pelletier Steps to reproduce: CREATE SCHEMA my_text_search_configuration; CREATE TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ( PARSER = "default" ); ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR asciihword WITH english_stem,simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR asciiword WITH english_stem,simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR email WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR file WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR float WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR host WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR hword WITH english_stem,simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR hword_asciipart WITH english_stem,simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR hword_numpart WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR hword_part WITH english_stem,simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR int WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR numhword WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR numword WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR sfloat WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR uint WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR url WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR url_path WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR version WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR word WITH english_stem,simple; pg_dump --schema my_text_search_configuration -- move schema out of the way to restore in same database ALTER SCHEMA my_text_search_configuration RENAME TO my_text_search_configuration_old; pg_restore psql properly displays the configuration \dF+ my_text_search_configuration.mytsconfig_english Text search configuration "my_text_search_configuration.mytsconfig_english" Parser: "pg_catalog.default" Token | Dictionaries -----------------+---------------------asciihword | english_stem,simpleasciiword | english_stem,simpleemail | simplefile | simplefloat | simplehost | simplehword | english_stem,simplehword_asciipart| english_stem,simplehword_numpart | simplehword_part | english_stem,simpleint | simplenumhword | simplenumword | simplesfloat | simpleuint | simpleurl | simpleurl_path | simpleversion | simpleword | english_stem,simple but after the restore, pgAdmin displays the following: CREATE TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ( PARSER = "default" ); ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR asciihword WITH simple,english_stem; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR asciiword WITH english_stem,simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR email WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR file WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR float WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR host WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR hword WITH english_stem,simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR hword_asciipart WITH english_stem,simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR hword_numpart WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR hword_part WITH simple,english_stem; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR int WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR numhword WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR numword WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR sfloat WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR uint WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR url WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR url_path WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR version WITH simple; ALTER TEXT SEARCH CONFIGURATION my_text_search_configuration.mytsconfig_english ADD MAPPING FOR word WITH simple,english_stem;
pgadmin-support by date: