From: | Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com> |
---|---|
To: | fabriziomello(at)gmail(dot)com |
Cc: | isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: vacuumdb for schema only |
Date: | 2010-09-08 13:10:39 |
Message-ID: | AANLkTikCASOTQbcw1RG7x_dp5txZ=hOwz3HeJfR2G4BT@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Enrico Weigelt | 2010-09-08 20:13:05 | Re: [NOVICE] - SAN/NAS/DAS - Need advises |
Previous Message | Fabrízio de Royes Mello | 2010-09-08 13:06:55 | Re: vacuumdb for schema only |