Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum behaviour in plpgsql function - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum behaviour in plpgsql function
Date
Msg-id 13020.1023147669@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum behaviour in plpgsql function  ("Alain Lavigne" <alavigne@zaq.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: "Joshua b. Jore"
Date:
Subject: Re: ctid & updates
Next
From: Tom Lane
Date:
Subject: Re: Subject: bool / vacuum full bug followup part 2