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

Hello Oliver,

sabato, 21 novembre 98, you wrote:

OE> Still trying to fix the bug with inherited check constraints...

OE> I have tried to create a min(oid) aggregate, but when I use it, I get
OE> the message `ERROR: fmgr_info: function 108994: cache lookup failed'.

OE> What is the problem, please?

OE> I created it thus:

OE> create function oid4smaller (oid, oid) returns oid as
OE> '/home/olly/cprogs/oidcompare.so' language 'c';

OE> create aggregate min (basetype = oid, sfunc1 = oid4smaller,
OE> stype1 = oid, stype2 = oid);

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';

create aggregate m (basetype = oid, sfunc1 = oid4smaller,
stype1 = oid, stype2 = oid);

prova=> select oid from a;
oid
------
376064
376065
380064
380065
380066
380067
(6 rows)

prova=> select min(oid) from a;
min
------
376064
(1 row)

-Jose'-