Re: Vacuum behaviour in plpgsql function

Thanks Tom, I didn't know. I will find another way to do it.

----------------------------------------------------------------------------------------
Alain Lavigne - Data Administrator - ZAQ Interactive Solutions E-Mail: alavigne(at)zaq(dot)com
297 St-Paul, West - Montreal, Quebec, Canada - H2Y 2A5
Phone: 514-282-7073 ext: 371 - Fax: 514-282-8011

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: June 3, 2002 19:41
To: Alain Lavigne
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Vacuum behaviour in plpgsql function

"Alain Lavigne" <alavigne(at)zaq(dot)com> writes:
> Using the function pgstatuple I want to use this to control what gets
> vacuumed.

You can't run VACUUM from inside a function because of memory-management
limitations. In current sources there is an error check to prevent you
from trying.

regards, tom lane