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