Skip site navigation (1) Skip section navigation (2)

Re: vacuumdb for schema only

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 (view raw or flat)
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.

In response to

pgsql-admin by date

Next:From: Enrico WeigeltDate: 2010-09-08 20:13:05
Subject: Re: [NOVICE] - SAN/NAS/DAS - Need advises
Previous:From: Fabrízio de Royes MelloDate: 2010-09-08 13:06:55
Subject: Re: vacuumdb for schema only

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group