vac=> \h vacuum
Command: vacuum
Description: vacuum the database, i.e. cleans out deleted records, updates statistics
Syntax:
vacuum [verbose] [analyze]
        or
vacuum [verbose] [analyze] table [analyze [(attr1, ... attrN)] ];
                                  ^^^^^^^
Imho, new ANALYZE syntax with attributes is quite unclear to me:

vac=> vacuum x (y);
PQexec() -- Request was sent to backend, but backend closed the channel before responding.
        This probably means the backend terminated abnormally before or while processing the request.

How about the next:

Syntax:
vacuum [verbose] [analyze] [table]
        or
vacuum [verbose] analyze table (attr1, ... attrN);

Vadim

Tue, 03 Feb 1998 11:07:04 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
vacuum analyze syntax in psql' help
> 
> vac=> \h vacuum
> Command: vacuum
> Description: vacuum the database, i.e. cleans out deleted records, updates statistics
> Syntax:
> vacuum [verbose] [analyze]
>         or
> vacuum [verbose] [analyze] table [analyze [(attr1, ... attrN)] ];
>                                   ^^^^^^^
> Imho, new ANALYZE syntax with attributes is quite unclear to me:

Oops, forgot to remove that second analyze.

> 
> vac=> vacuum x (y);
> PQexec() -- Request was sent to backend, but backend closed the channel before responding.
>         This probably means the backend terminated abnormally before or while processing the request.
> 
> How about the next:
> 
> Syntax:
> vacuum [verbose] [analyze] [table]
>         or
> vacuum [verbose] analyze table (attr1, ... attrN);
> 
> Vadim
> 

Much better.

-- 
Bruce Momjian
maillist@candle.pha.pa.us

Mon, 2 Feb 1998 23:33:59 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: vacuum analyze syntax in psql' help
Bruce Momjian wrote:
> 
> > vac=> vacuum x (y);
> > PQexec() -- Request was sent to backend, but backend closed the channel before responding.
> >         This probably means the backend terminated abnormally before or while processing the request.

Will you fix this ?

> >
> > How about the next:
> >
> > Syntax:
> > vacuum [verbose] [analyze] [table]
> >         or
> > vacuum [verbose] analyze table (attr1, ... attrN);

And this ?

Vadim

Tue, 03 Feb 1998 12:11:03 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Re: [HACKERS] Re: vacuum analyze syntax in psql' help
Done.  Manual page, psql help, and error message fixed.

> 
> vac=> \h vacuum
> Command: vacuum
> Description: vacuum the database, i.e. cleans out deleted records, updates statistics
> Syntax:
> vacuum [verbose] [analyze]
>         or
> vacuum [verbose] [analyze] table [analyze [(attr1, ... attrN)] ];
>                                   ^^^^^^^
> Imho, new ANALYZE syntax with attributes is quite unclear to me:
> 
> vac=> vacuum x (y);
> PQexec() -- Request was sent to backend, but backend closed the channel before responding.
>         This probably means the backend terminated abnormally before or while processing the request.
> 
> How about the next:
> 
> Syntax:
> vacuum [verbose] [analyze] [table]
>         or
> vacuum [verbose] analyze table (attr1, ... attrN);
> 
> Vadim
> 


-- 
Bruce Momjian
maillist@candle.pha.pa.us

Tue, 3 Feb 1998 14:25:04 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: vacuum analyze syntax in psql' help