Thanks Tom, I didn't know. I will find another way to do it.
----------------------------------------------------------------------------------------
Alain Lavigne - Data Administrator - ZAQ Interactive Solutions E-Mail: alavigne@zaq.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@sss.pgh.pa.us]
Sent: June 3, 2002 19:41
To: Alain Lavigne
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Vacuum behaviour in plpgsql function
"Alain Lavigne" <alavigne@zaq.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