Hi there
Postgresql 8.4.
I keep getting this error multiple times when I tried to access the pg_catalog in pg_admin:
Cache lookup failed for text search parser 3722.
The logs show that the query that was being executed was: (example is one of many)
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=11299::oid
ORDER BY 1, mapseqno
What I found was that my database does not have the default text search parser with oid 3722.
Is someone able to tell me it's origin so I can back track and get it in the database. I could easily generate it manually but it will have a different oid which is a no go because pg_ts_parser specifies 3722 and the records in pg_ts_config specify parsar as 3722 also.
Many thanks
R Clarke