Text Search Configuration Mapping displayed out of order, pgAdmin 1.10.0

From: "Jean-Pierre Pelletier" <jppelletier(at)e-djuster(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Cc: "Allen Vachon" <avachon(at)e-djuster(dot)com>, "Mark Rollins" <mrollins(at)e-djuster(dot)com>, "Dave Sugden" <dsugden(at)e-djuster(dot)com>, "Fabio Katz" <fkatz(at)e-djuster(dot)com>, "Benoit Rouleau" <brouleau(at)e-djuster(dot)com>
Subject: Text Search Configuration Mapping displayed out of order, pgAdmin 1.10.0
Date: 2009-11-11 18:06:24
Message-ID: 8A7EEE5FC42A49BFABE5D103F1ECA459@edjuster.network
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,simple
asciiword | english_stem,simple
email | simple
file | simple
float | simple
host | simple
hword | english_stem,simple
hword_asciipart | english_stem,simple
hword_numpart | simple
hword_part | english_stem,simple
int | simple
numhword | simple
numword | simple
sfloat | simple
uint | simple
url | simple
url_path | simple
version | simple
word | 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;

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Raymond O'Donnell 2009-11-11 18:08:09 Re: PostgreSQL 8.5
Previous Message Vladimir Kokovic' 2009-11-11 18:01:31 PostgreSQL 8.5