Re: [HACKERS] Error "vacuum pg_proc"

Tom Lane writes:
> Mateus Cordeiro Inssa <mateus(at)ifnet(dot)com(dot)br> writes:
> > I got this error vacuuming pg_proc:
> > ERROR: _bt_endpoint: leftmost page (20) has not leftmost flag
>
> Hmm, I wonder if this could be yet another manifestation of the problems
> that btree indexes have with oversized key values. Do you have any
> procedures with long definitions? "Long" in this context means over
> about 4K. If you're not sure, try
> select proname from pg_proc where length(prosrc) > 4000;

Yes, I have some functions from 3k to 5k.

> If you do, try breaking them up into smaller procedures. You might have
> to dump and rebuild the database to get rid of the corruption in
> pg_proc's index, though.

Ok.

> The prosrc index is actually completely unnecessary, so we've removed
> it for 7.0. Work is in progress to fix the tuple-size problem as well,
> but that will probably take longer.

Oh, I would ask why there was this index. I had problems with it
since version 6.4.

I'd like to suggest the creation of a new command: ALTER FUNCTION. I
use pltcl to program in the server, so, no need for checking the
function code. The problems with pg_proc always occurred to me when
changing functions: DROP/CREATE. This command would do just an update on
prosrc field (that doesn't have index anymore).

[]'s

Mateus Cordeiro Inssa
---------------------
Linux User: 76186 Kernel: 2.3.34
ICQ (Licq): 15243895
---------------------
mateus(at)ifnet(dot)com(dot)br
mateus(at)cwb(dot)fnn(dot)net

Mon Dec 27 11:15:41 EDT 1999
.