From: | Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | No Default Text Search Parser |
Date: | 2012-09-04 14:19:42 |
Message-ID: | CAMChtddvKKsEpBebKYYSejfAKaL=5+kvH2pGmJtuYgejN+LC2A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2012-09-04 14:43:10 | Re: Would my postgresql 8.4.12 profit from doubling RAM? |
Previous Message | Chris Travers | 2012-09-04 14:16:49 | Re: Databas has no Object Identifier Types & Functions |