Re: VACUUM AND VACUUM ANALYSE

From: Jim Mercer <jim(at)reptiles(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: VACUUM AND VACUUM ANALYSE
Date: 2000-11-08 17:46:53
Message-ID: 20001108124653.F16128@reptiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On Wed, Nov 08, 2000 at 06:37:55PM +0100, Mickaël Jouanne wrote:
> 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"
>
> But cvdb is a working table.
>
> Does someone have a idea of the error ?

yep.

i spent months trying to track this one down.

try:
EDEN=> VACUUM ANALYZE cvdb;
^
^^^
^^^^^

seriously, i did actually beat my head against the wall until i realized
the spelling mistake.

--
[ Jim Mercer jim(at)reptiles(dot)org +1 416 410-5633 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2000-11-08 17:51:52 Re: VACUUM AND VACUUM ANALYSE
Previous Message Thomas Good 2000-11-08 17:46:16 Re: [NOVICE] VACUUM AND VACUUM ANALYSE

Browse pgsql-novice by date

  From Date Subject
Next Message Biff Farell 2000-11-08 17:49:59 Upgrade 6.3 to 7.02
Previous Message Thomas Good 2000-11-08 17:46:16 Re: [NOVICE] VACUUM AND VACUUM ANALYSE