VACUUM AND VACUUM ANALYSE

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

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