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@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