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 |
|______________________________________________________________|
