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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-novice by date

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

pgsql-general by date

Next:From: Oliver ElphickDate: 2000-11-08 17:51:52
Subject: Re: VACUUM AND VACUUM ANALYSE
Previous:From: Thomas GoodDate: 2000-11-08 17:46:16
Subject: Re: [NOVICE] VACUUM AND VACUUM ANALYSE

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