From: | "Culberson, Philip" <philip(dot)culberson(at)dat(dot)com> |
---|---|
To: | "'Arnaud FLORENT'" <aflorent(at)iris-tech(dot)fr>, PostgreSQL general ML <pgsql-general(at)hub(dot)org> |
Subject: | RE: [GENERAL] VACUUM ANALYSE |
Date: | 2000-02-01 16:27:14 |
Message-ID: | A95EFC3B707BD311986C00A0C9E95B6A9DE380@datmail03.dat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
There is a typo in your spelling of "analyze". The correct syntax is:
devdb=> \h vacuum
Command: vacuum
Description: vacuum the database, i.e. cleans out deleted records, updates
statistics
Syntax:
VACUUM [VERBOSE] [ANALYZE] [table]
or
VACUUM [VERBOSE] ANALYZE [table [(attr1, ...attrN)]];
Phil Culberson
DAT Services
-----Original Message-----
From: Arnaud FLORENT [mailto:aflorent(at)iris-tech(dot)fr]
Sent: Tuesday, February 01, 2000 7:34 AM
To: PostgreSQL general ML
Subject: [GENERAL] VACUUM ANALYSE
hello,
this command (VACUUM ANALYSE) doesn't work with my 6.5.2 postgres......
error message:
NOTICE: Vacuum: table not found
any suggestion?
--
______________________________
Arnaud FLORENT
IRIS Technologies
phone: (33) 03 20 65 85 80
fax: (33) 03 20 65 85 81
GSM: (33) 06 15 14 32 90
mailto:aflorent(at)iris-tech(dot)fr
______________________________
************
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2000-02-01 20:02:17 | Re: [GENERAL] Rebuilding 6.5.3 RPMs |
Previous Message | Ed Loehr | 2000-02-01 16:20:27 | Re: [GENERAL] VACUUM ANALYSE |