Nice to know that, which means we can only send out scripts by cron... On 8 September 2010 16:06, Fabrízio de Royes Mello <[email protected]>wrote:
> > > 2010/9/8 Bèrto ëd Sèra <[email protected]> > > Hi! >> >> I would also expect you to be able to make a Stored Procedure executing >> the same command, although I never tried it myself. >> >> > It is not possible... vacuum cannot be executed inside a function or > transaction. > > See de sample: > > -- Using function > CREATE OR REPLACE FUNCTION fc_vacuum(TEXT) RETURNS VOID AS > $$ > BEGIN > EXECUTE 'VACUUM '||$1; > RETURN; > END; > $$ > LANGUAGE plpgsql; > > > postg...@bdteste=# select fc_vacuum('foo'); > ERROR: VACUUM cannot be executed from a function > CONTEXT: SQL statement "VACUUM foo" > PL/pgSQL function "fc_vacuum" line 2 at execute statement > > > -- Using transaction > postg...@bdteste=# begin; > BEGIN > postg...@bdteste=# VACUUM foo; > ERROR: VACUUM cannot run inside a transaction block > > > Best regards, > > -- > Fabrízio de Royes Mello > >> Blog sobre TI: http://fabriziomello.blogspot.com > >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello > > -- ============================== Constitution du 24 juin 1793 - Article 35. - Quand le gouvernement viole les droits du peuple, l'insurrection est, pour le peuple et pour chaque portion du peuple, le plus sacré des droits et le plus indispensable des devoirs.
