Thread: VACUUM AND VACUUM ANALYSE
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
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. ]
=?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
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
Bruce Momjian wrote: >We can get it to accept either spelling, if that is appropriate. Well, since "analyse" is what I would automatically use, that would be a good thing. I can't at the moment think of any other differences between English and American that affect the parser. -- 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
Sure, no problem. We will only document the 'z' spelling, but accept both. > Bruce Momjian wrote: > >We can get it to accept either spelling, if that is appropriate. > > Well, since "analyse" is what I would automatically use, that would be > a good thing. > > I can't at the moment think of any other differences between English > and American that affect the parser. > > -- > 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
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
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
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
--------------------------------------------------------------------