fulltextindex function problem - Mailing list pgsql-general
From | Petr Vanicek |
---|---|
Subject | fulltextindex function problem |
Date | |
Msg-id | 9903151141.ZM12230@vinnetou.site.cas.cz Whole thread Raw |
List | pgsql-general |
on using fti function at fulltextindex contrib packages Iam problem. System: OSF1 V3.2C Postmaster: postgresql-6.4.2 start ./bin/postmaster -i -B 256 -d 3 ************************************ Debug outpout: ************************************ bash$ FindExec: found "/home/serv_data/SQL/./bin/postgres" using argv[0] binding ShmemCreate(key=52e2c1, size=2513064) ./bin/postmaster: ServerLoop: handling reading 5 ./bin/postmaster: ServerLoop: handling reading 5 ./bin/postmaster: ServerLoop: handling writing 5 ./bin/postmaster: BackendStartup: environ dump: ----------------------------------------- LOGNAME=postgres LD_LIBRARY_PATH=/home/serv_data/SQL/lib/ TERM=xterm HOSTTYPE=alpha PATH=/usr/bin:.:/home/serv_data/SQL/bin HOME=/home/serv_data/SQL SHELL=/bin/bash PGLIB=/home/serv_data/SQL/lib USER=postgres PGDATA=/home/serv_data/SQL/data MANPATH=:/home/serv_data/SQL/man OSTYPE=OSF1 SHLVL=1 _=./bin/postmaster POSTPORT=5432 POSTID=2147483647 PG_USER=postgres IPC_KEY=5432000 ----------------------------------------- ./bin/postmaster: BackendStartup: pid 28419 user postgres db katalog socket 5 ./bin/postmaster child[28419]: starting with (/home/serv_data/SQL/./bin/postgres, -p, -d3, -P5, -B, 256, -v131072, katalog, ) FindExec: found "/home/serv_data/SQL/./bin/postgres" using argv[0] debug info: User = postgres RemoteHost = localhost RemotePort = 0 DatabaseName = katalog Verbose = 3 Noversion = f timings = f dates = Normal bufsize = 256 sortmem = 512 query echo = f InitPostgres StartTransactionCommand query: INSERT INTO spkk VALUES (00000000000000000001,'Obrazova encyklopedie mody','Kyba lova Ludmila%Herbenova Olga%Lamarova Milena%','Praha. Artia, 1973','Odivani - vy voj - encyklopedie obrazove','II 69333'); ProcessQuery ERROR: fmgr_info: function 113281: cache lookup failed AbortCurrentTransaction ********************************** END debug output ********************************** psql shell bash$ psql katalog Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL type \? for help on slash commands type \q to quit type \g or terminate with semicolon to execute query You are currently connected to the database: katalog katalog=> INSERT INTO spkk VALUES (00000000000000000001,'Obrazova encyklopedie mody','Kybalova Ludmila%Herbenova Olga%Lamarova Milena%','Praha. Artia, 1973','Odivani - vyvoj - encyklopedie obrazove','II 69333'); ERROR: fmgr_info: function 113281: cache lookup failed *************************************** Database, function definition and triger creating along README and fti.c. ~sourcetree/contrib/fulltextindex/ ******************************************************* equal problem with using linux working correctly. Please help mee. Sorry my language Ing. Petr Vanicek ______________________________________________________________ | | UTIA AV CR | |tel.: 6605 2233 | Pod vodarenskou vezi 4 | | 6605 2364 | Praha 8 | |fax.: 688 46 77 | | |--------------------------------------------------------------| |vanicekp@utia.cas.cz | |vanicekp@vinnetou.site.cas.cz | |http://www.utia.cas.cz/user_data/vanicekp/home.html | |______________________________________________________________|
pgsql-general by date: