Re: User function canceling VACUUMDB utility

Hi,

Yes, once correct schema was included in the search_path, VACUUM and ANALYZE
run fine again.

Thank you!

On Fri, Sep 10, 2010 at 11:38 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Carlos Henrique Reimer <carlos(dot)reimer(at)opendb(dot)com(dot)br> writes:
> > Yes, you're right! I found out a functional index using this function and
> > ANALYZE also cancels.
>
> > Is there a way to code this function in a way VACUUM/ANALYZE does not
> > cancel?
>
> I think your problem is probably a search_path issue, ie vacuumdb is not
> running with the "BRASIL" schema in its path so the column reference
> fails to resolve. You should be able to add the schema name to the
> %TYPE reference. Or, if you can't make that work, just don't use
> %TYPE...
>
> regards, tom lane
>

--
Reimer
47-3347-1724 47-9183-0547 msn: carlos(dot)reimer(at)opendb(dot)com(dot)br