Re: User function canceling VACUUMDB utility

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carlos Henrique Reimer <carlos(dot)reimer(at)opendb(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: User function canceling VACUUMDB utility
Date: 2010-09-13 14:47:23
Message-ID: 12176.1284389243@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Carlos Henrique Reimer <carlos(dot)reimer(at)opendb(dot)com(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Brinkman 2010-09-13 15:17:51 I keep getting "type does not exist" on compile of this SETOF function (list 2 table)
Previous Message Tom Lane 2010-09-13 14:41:00 Re: Query plan choice issue