Re: VACUUM AND VACUUM ANALYSE - Mailing list pgsql-general

From Jim Mercer
Subject Re: VACUUM AND VACUUM ANALYSE
Date
Msg-id 20001108124653.F16128@reptiles.org
Whole thread Raw
In response to VACUUM AND VACUUM ANALYSE  (Mickaël Jouanne <m.jouanne@apr-job.com>)
List pgsql-general
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.  ]

pgsql-general by date:

Previous
From: Mickaël Jouanne
Date:
Subject: VACUUM AND VACUUM ANALYSE
Next
From: "Oliver Elphick"
Date:
Subject: Re: VACUUM AND VACUUM ANALYSE