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@debis.com (Jan Wieck) #