Re: [NOVICE] VACUUM AND VACUUM ANALYSE

From: Thomas Good <tomg(at)q8(dot)nrnet(dot)org>
To: Mickaël Jouanne <m(dot)jouanne(at)apr-job(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] VACUUM AND VACUUM ANALYSE
Date: 2000-11-08 17:46:16
Message-ID: Pine.LNX.3.96.1001108124322.4034A-100000@q8.nrnet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On Wed, 8 Nov 2000, [iso-8859-1] Mickal Jouanne wrote:

> Hello !
>
> I want to do a VACUUM ANALYSE on some tables but when i do :
>
> EDEN=> VACUUM ANALYSE cvdb;
> ERROR: parser: parse error at or near "cvdb"

Yes, it is a spelling difference.
vacuum verbose analyze tabname;

> But cvdb is a working table.
>
> Does someone have a idea of the error ?
>
> thanks a lot !
>
> --
>
> Mickal JOUANNE
> Webmaster / Developpeur / Support Technique
>
>
> APR-Job &
> www.jobscout24.fr - Meet your future
> _____________________________________
>
> HumanLine France SAS
> 32, rue Pierret
> 92200 Neuilly
>
> tel: +33 1 42 44 40 73
> fax: +33 1 49 26 09 76
> ICQ: 42799256
> m(dot)jouanne(at)humanline(dot)fr
>

--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
IS Coordinator / DBA Phone: 718-354-5528
Fax: 718-354-5056
--------------------------------------------------------------------
Powered by: PostgreSQL s l a c k w a r e FreeBSD:
RDBMS |---------- linux The Power To Serve
--------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Mercer 2000-11-08 17:46:53 Re: VACUUM AND VACUUM ANALYSE
Previous Message Mickaël Jouanne 2000-11-08 17:37:55 VACUUM AND VACUUM ANALYSE

Browse pgsql-novice by date

  From Date Subject
Next Message Jim Mercer 2000-11-08 17:46:53 Re: VACUUM AND VACUUM ANALYSE
Previous Message Mickaël Jouanne 2000-11-08 17:37:55 VACUUM AND VACUUM ANALYSE