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

>
> I still can't get this type creation working.  I get the subject error
> whenever I try to select on the new type if it is indexed.  Here is a sample.
>
> darcy=> create table x (g glaccount, i int);
> CREATE
> darcy=> insert into x values ('12345-0000', 1);
> INSERT 29124 1
> darcy=> select * from x where g = '12345-0000';
>          g|i
> ----------+-
> 12345-0000|1
> (1 row)
>
> darcy=> create unique index y on x (g);
> CREATE
> 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.


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) #