Re: User function canceling VACUUMDB utility

Carlos Henrique Reimer <carlos.reimer@opendb.com.br> writes:
> We are facing the following problem in a PG 8.2 server when trying to vacuum
> one of our databases:
> vacuumdb: vacuuming of database "reimer" failed: ERROR:  invalid type name
> "TT_TIT.SEQCAN%TYPE"
> [ which seems to be coming from out-of-date code in a function ]

> If I drop the function the vacuumdb runs fine but I'm wondering how a
> funciton can cancel the vacuumdb utility.

Perhaps you have a functional index that calls that function?  If
so, ANALYZE would probably try to call the function too.

            regards, tom lane