Thread: fulltextindex function problem

fulltextindex function problem

From
"Petr Vanicek"
Date:
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           |
|______________________________________________________________|