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
