Re: VACUUM AND VACUUM ANALYSE

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: Mickaël Jouanne <m(dot)jouanne(at)apr-job(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: VACUUM AND VACUUM ANALYSE
Date: 2000-11-08 21:27:34
Message-ID: 200011082127.QAA11284@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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(dot)Elphick(at)lfix(dot)co(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mikheev, Vadim 2000-11-08 21:30:11 RE: Really SLOW using GROUP BY ...!?
Previous Message Tom Lane 2000-11-08 21:26:44 Re: Really SLOW using GROUP BY ...!?

Browse pgsql-novice by date

  From Date Subject
Next Message Charles Curley 2000-11-08 22:20:29 Re: [NOVICE] Re: VACUUM AND VACUUM ANALYSE
Previous Message Poul Kristensen 2000-11-08 20:36:54 migrating MSAccess to pgsql7.0 on RH 6.2 through odbc