fulltextindex function problem

From: "Petr Vanicek" <vanicekp(at)vinnetou(dot)site(dot)cas(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: fulltextindex function problem
Date: 1999-03-15 10:41:31
Message-ID: 9903151141.ZM12230@vinnetou.site.cas.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)utia(dot)cas(dot)cz |
|vanicekp(at)vinnetou(dot)site(dot)cas(dot)cz |
|http://www.utia.cas.cz/user_data/vanicekp/home.html |
|______________________________________________________________|

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1999-03-15 14:26:20 Re: [GENERAL] Error
Previous Message Herouth Maoz 1999-03-15 10:15:34 Re: [GENERAL] The value returned by autoinc ?