Re: User function canceling VACUUMDB utility
| От | Carlos Henrique Reimer |
|---|---|
| Тема | Re: User function canceling VACUUMDB utility |
| Дата | |
| Msg-id | AANLkTi=4fRsph+7Lbxgv5+ZazDmdOcEh5JabnoRofExD@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: User function canceling VACUUMDB utility (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: User function canceling VACUUMDB utility
|
| Список | pgsql-general |
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@sss.pgh.pa.us> wrote:
Carlos Henrique Reimer <carlos.reimer@opendb.com.br> writes:> Yes, you're right! I found out a functional index using this function andI think your problem is probably a search_path issue, ie vacuumdb is not
> ANALYZE also cancels.
> Is there a way to code this function in a way VACUUM/ANALYZE does not
> cancel?
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.reimer@opendb.com.br
В списке pgsql-general по дате отправления: