Re: User function canceling VACUUMDB utility - Mailing list pgsql-general

From Tom Lane
Subject Re: User function canceling VACUUMDB utility
Date
Msg-id 12176.1284389243@sss.pgh.pa.us
Whole thread Raw
In response to Re: User function canceling VACUUMDB utility  (Carlos Henrique Reimer <carlos.reimer@opendb.com.br>)
List pgsql-general
Carlos Henrique Reimer <carlos.reimer@opendb.com.br> writes:
> Yes, once correct schema was included in the search_path, VACUUM and ANALYZE
> run fine again.

You'd be better advised to fix the function so it works regardless of
caller's search_path.  As-is, it's a loaded gun pointed at your foot.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query plan choice issue
Next
From: Dimitri Fontaine
Date:
Subject: Re: Good candidate query for window syntax?