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 <t...@sss.pgh.pa.us> wrote: > Carlos Henrique Reimer <carlos.rei...@opendb.com.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.rei...@opendb.com.br
