Re: Vacuum behaviour in plpgsql function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alain Lavigne" <alavigne(at)zaq(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Vacuum behaviour in plpgsql function
Date: 2002-06-03 23:41:09
Message-ID: 13020.1023147669@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-06-03 23:43:41 Re: Subject: bool / vacuum full bug followup part 2
Previous Message chunxia xu 2002-06-03 22:37:29 create rule