Skip site navigation (1) Skip section navigation (2)

[pgAdmin III] #91: Text Search Configuration Mapping displayed out of order, pgAdmin 1.10.0

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #91: Text Search Configuration Mapping displayed out of order, pgAdmin 1.10.0
Date: 2009-11-16 18:08:20
Message-ID: 062.6785678a52d86575b0e67e9f94cd8cd2@code.pgadmin.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
#91: Text Search Configuration Mapping displayed out of order, pgAdmin 1.10.0
-----------------------------------+----------------------------------------
 Reporter:  Jean-Pierre Pelletier  |       Owner:  dpage 
     Type:  bug                    |      Status:  new   
 Priority:  minor                  |   Milestone:  1.10.1
Component:  pgadmin                |     Version:  1.10  
 Keywords:  textsearch             |    Platform:  all   
-----------------------------------+----------------------------------------
 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;

-- 
Ticket URL: <http://code.pgadmin.org/trac/ticket/91>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

Responses

pgadmin-hackers by date

Next:From: pgAdmin TracDate: 2009-11-16 18:08:31
Subject: Re: [pgAdmin III] #91: Text Search Configuration Mapping displayed out of order, pgAdmin 1.10.0
Previous:From: Albe LaurenzDate: 2009-11-16 08:07:36
Subject: Suggestion for pgAgent

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group