Re: [HACKERS] pg_dump bug - problems along the way

>
> Sferacarta Software wrote:
> >Try this...it works...
> >
> >create function oid4smaller (oid, oid) returns oid as
> >'
> >begin
> > if $1 > $2 then
> > return $2;
> > else
> > return $1;
> > end if;
> > end;
> >' language 'plpgsql';
>
> I'm afraid it doesn't work for me; clearly the problem is elsewhere:
>
> bray=> select min(oid) from europe;
> ERROR: fmgr_info: function 108994: cache lookup failed
>
> **Idea** - try in another database -- it works, so it must be a database
> corruption of some kind.

Looks like you dropped and recreated the function used in the
min(oid) aggregate without dropping and recreating the
aggregate itself.

Note that the functions used in an aggregate are referenced
by OID, not by name. In pg_aggregate the pg_proc tuple with
the old OID is still referenced and cannot be found (cache
lookup failed). Drop the agg and recreate it.

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