Thread: VACUUM AND VACUUM ANALYSE

VACUUM AND VACUUM ANALYSE

From
Mickaël Jouanne
Date:
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: [GENERAL] VACUUM AND VACUUM ANALYSE

From
Jim Mercer
Date:
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.  ]

Re: VACUUM AND VACUUM ANALYSE

From
Thomas Good
Date:
On Wed, 8 Nov 2000, [iso-8859-1] Micka�l 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 !
>
> --
>
> 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
>


--------------------------------------------------------------------
               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: [GENERAL] VACUUM AND VACUUM ANALYSE

From
"Oliver Elphick"
Date:
=?iso-8859-1?Q?Micka=EBl_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"
  >
  >But cvdb is a working table.
  >
  >Does someone have a idea of the error ?


It's "ANALYZE" (those Americans just don't know how to spell!)


--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "And whosoever liveth and believeth in me shall never
      die. Believest thou this?"    John 11:26



Re: [GENERAL] VACUUM AND VACUUM ANALYSE

From
Bruce Momjian
Date:
We can get it to accept either spelling, if that is appropriate.

[ Charset ISO-8859-1 unsupported, converting... ]
> =?iso-8859-1?Q?Micka=EBl_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"
>   >
>   >But cvdb is a working table.
>   >
>   >Does someone have a idea of the error ?
>
>
> It's "ANALYZE" (those Americans just don't know how to spell!)
>
>
> --
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight                              http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>                  ========================================
>      "And whosoever liveth and believeth in me shall never
>       die. Believest thou this?"    John 11:26
>
>
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: [GENERAL] VACUUM AND VACUUM ANALYSE

From
Bruce Momjian
Date:
Ok, it will now accept ANALYSE in the current source tree.


[ Charset ISO-8859-1 unsupported, converting... ]
> =?iso-8859-1?Q?Micka=EBl_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"
>   >
>   >But cvdb is a working table.
>   >
>   >Does someone have a idea of the error ?
>
>
> It's "ANALYZE" (those Americans just don't know how to spell!)
>
>
> --
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight                              http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>                  ========================================
>      "And whosoever liveth and believeth in me shall never
>       die. Believest thou this?"    John 11:26
>
>
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: Re: [GENERAL] VACUUM AND VACUUM ANALYSE

From
Charles Curley
Date:
On Wed, Nov 08, 2000 at 05:51:52PM +0000, Oliver Elphick wrote:
> =?iso-8859-1?Q?Micka=EBl_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"
>   >
>   >But cvdb is a working table.
>   >
>   >Does someone have a idea of the error ?
>
>
> It's "ANALYZE" (those Americans just don't know how to spell!)

"Forgive him, Caesar, for [Britannus] is a barbarian, and thinks that the
customs of his tribe and island are laws of nature."

George Barnard Shaw, "Julius Caesar"

(quoted and cited from memory)

:-)

--

        -- C^2

No windows were crashed in the making of this email.

Looking for fine software and/or web pages?
http://w3.trib.com/~ccurley
Attachment