I'm having some trouble using a hash index on an INT8 field in
postgres7.0(release):
test=# CREATE TABLE index_test (test_attr INT8);
CREATE
test=# CREATE INDEX index_test_attr_idx ON index_test USING hash (test_attr);
CREATE
test=# INSERT INTO index_test VALUES (199);
ERROR: fmgr_info: function 0: cache lookup failed
test=# DROP INDEX index_test_attr_idx;
DROP
test=# INSERT INTO index_test VALUES (199);
INSERT 593453 1
test=# CREATE INDEX index_test_attr_idx ON index_test USING hash (test_attr);
ERROR: fmgr_info: function 0: cache lookup failed
test=#
I can work around this just fine by using a btree in this particular case, since
the difference isn't really all that major (although I know that the field I
want this for will only ever be limited with an "=" operator), but since I
didn't see any reference to this problem in the docs or the archives that I
searched, I thought I would bring it to the attention of the list to see if
anyone might know what could cause this error.
I'm running postgres under RH Linux 6.2 on a dual pIII 733 with 512Mb RAM,
complied with:
NAMEDATALEN 64
BLCKSZ 32768
All regression tests passed (except the ones relating to names, of course)
I start up postgres with the following line:
pg_ctl -o "-i -N 128 -B 256 -o \"-S 2048\" >>postgres.log 2>&1 </dev/null" start
Does anyone have any ideas?
Thanx,
-phil
BTW...sorry if I missed something in the docs/archives and this is a known
problem
