Re: Text Search Configuration Mapping displayed out of order, pgAdmin 1.10.0

Le vendredi 13 novembre 2009 à 17:09:33, Jean-Pierre Pelletier a écrit :
> To reverse engineer the definition of a text search configuration, pgAdmin
> uses a query with an incomplete ORDER BY such as:
>
> SELECT
>    (SELECT t.alias FROM pg_catalog.ts_token_type(cfgparser) AS t WHERE
> t.tokid = maptokentype) AS tokenalias,
>    dictname
> FROM
>    pg_ts_config_map
>
>    LEFT OUTER JOIN pg_ts_config
>    ON mapcfg=pg_ts_config.oid
>
>    LEFT OUTER JOIN pg_ts_dict
>    ON mapdict=pg_ts_dict.oid
> WHERE
>    mapcfg = 3743899::oid
> ORDER BY
>    1;
>
> The ORDER BY is missing column "mapseqno" from catalog "pg_ts_config_map".
>
> As explained before, in our case, the problem was only exposed after
> reloading the text search configuration using pg_restore.
>

Sorry that I didn't find the time to work on this till today. You're right on
the bug and the fix. I commited your fix, thanks a lot.


--
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com