Re: [HACKERS] Help: fmgr_info: function 0: cache lookup failed

Thus spake Jan Wieck
> > darcy=> select * from x where g = '12345-0000';
> > ERROR:  fmgr_info: function 0: cache lookup failed
> >
> > As you can see, the select worked until I added the index.  Here is the
> > SQL that created the glaccount type.  I hope to rewrite the documentation
> > based on this but I need to get it working first.  Any ideas?
> 
>     I can only guess - in contrast to the builtin operators, user
>     created ones don't specify the index  selectivity  functions.
>     Maybe you need to manipulate the pg_operator entries manually
>     to be able to create indices too. AFAICS there  is  no  check
>     made on the fmgr call in selfuncs.c.

I tried just setting oprcanhash to true but that didn't do it.  Can
you suggest what fields I need to look at in pg_operator?

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.