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?

oprrest and oprjoin

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #