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(at)debis(dot)com (Jan Wieck) #