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.org http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
