Re: vacuumdb for schema only

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
<fabriziomello(at)gmail(dot)com>wrote:

>
>
> 2010/9/8 Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com>
>
> 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;
>
>
> postgres(at)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
> postgres(at)bdteste=# begin;
> BEGIN
> postgres(at)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.