Carlos Henrique Reimer <carlos.reimer@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
