Re: VACUUM AND VACUUM ANALYSE

Jim Mercer <jim@reptiles.org>

From: Jim Mercer <jim@reptiles.org>
To: Mickaël Jouanne <m.jouanne@apr-job.com>
Cc: pgsql-general@postgresql.org, pgsql-novice@postgresql.org
Date: 2000-11-08T17:46:53Z
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@reptiles.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.  ]