Thread

VACUUM AND VACUUM ANALYSE

Mickaël Jouanne <m.jouanne@apr-job.com> — 2000-11-08T17:37:55Z

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"

But cvdb is a working table.

Does someone have a idea of the error ?

thanks a lot !

-- 

Mickaël 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.jouanne@humanline.fr

Re: [NOVICE] VACUUM AND VACUUM ANALYSE

Thomas Good <tomg@q8.nrnet.org> — 2000-11-08T17:46:16Z

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.jouanne@humanline.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
--------------------------------------------------------------------

Re: VACUUM AND VACUUM ANALYSE

Jim Mercer <jim@reptiles.org> — 2000-11-08T17:46:53Z

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.  ]