From richard@ibisaustralia.com Wed Sep  10 12:42:00 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id DF125D1B506
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Sep 2003 12:42:00 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 43928-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Sep 2003 09:41:33 -0300 (ADT)
Received: from server146.hostingrevolution.com
	(server146.hostingrevolution.com [64.21.143.245])
	by svr1.postgresql.org (Postfix) with ESMTP id BC4E6D1B4FE
	for <pgsql-sql@postgresql.org>; Wed, 10 Sep 2003 09:41:29 -0300 (ADT)
Received: from 123.c.002.pth.iprimus.net.au ([210.50.110.123] helo=athlon2000)
	by server146.hostingrevolution.com with smtp (Exim 4.22)
	id 19x4Ho-0007bR-3h
	for pgsql-sql@postgresql.org; Wed, 10 Sep 2003 07:41:06 -0500
Message-ID: <004001c37799$2367c250$7b6e32d2@athlon2000>
From: "Richard Sydney-Smith" <richard@ibisaustralia.com>
To: <pgsql-sql@postgresql.org>
Subject: how to vacum
Date: Wed, 10 Sep 2003 20:43:25 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_003D_01C377DC.2EEF6FE0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-AntiAbuse: This header was added to track abuse,
	please include it with any abuse report
X-AntiAbuse: Primary Hostname - server146.hostingrevolution.com
X-AntiAbuse: Original Domain - postgresql.org
X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12]
X-AntiAbuse: Sender Address Domain - ibisaustralia.com
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_60_70
X-Spam-Level: 
X-Archive-Number: 200309/79
X-Sequence-Number: 15057

This is a multi-part message in MIME format.

------=_NextPart_000_003D_01C377DC.2EEF6FE0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Tried to issue the command "vacum full" both from psql and the sql box in p=
gadmin without success.

How do you use the command?

select vacum full;=20

also does not work

Lost in the woods please help

Richard


------=_NextPart_000_003D_01C377DC.2EEF6FE0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Tried to issue the command "vacum full" bo=
th from=20
psql and the sql box in pgadmin without success.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>How do you use the command?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>select vacum full; </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>also does not work</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Lost in the woods please help</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Richard</FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_003D_01C377DC.2EEF6FE0--




From erik@thiele-hydraulik.de Wed Sep  10 12:57:24 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 4B91BD1B547
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Sep 2003 12:57:24 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 54397-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Sep 2003 09:56:55 -0300 (ADT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.177])
	by svr1.postgresql.org (Postfix) with ESMTP id 18B9FD1B542
	for <pgsql-sql@postgresql.org>; Wed, 10 Sep 2003 09:56:52 -0300 (ADT)
Received: from [212.227.126.161] (helo=mrelayng.kundenserver.de)
	by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
	id 19x4Wk-0007xY-00; Wed, 10 Sep 2003 14:56:54 +0200
Received: from [80.131.205.229] (helo=goofy.thiele-intern)
	by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1)
	id 19x4Wj-0003c7-00; Wed, 10 Sep 2003 14:56:53 +0200
Date: Wed, 10 Sep 2003 14:56:52 +0200
From: Erik Thiele <erik@thiele-hydraulik.de>
To: "Richard Sydney-Smith" <richard@ibisaustralia.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: how to vacum
Message-Id: <20030910145652.0c664b95.erik@thiele-hydraulik.de>
In-Reply-To: <004001c37799$2367c250$7b6e32d2@athlon2000>
References: <004001c37799$2367c250$7b6e32d2@athlon2000>
Organization: Thiele-Hydraulik
X-Mailer: Sylpheed version 0.8.10 (GTK+ 1.2.10; i686-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/83
X-Sequence-Number: 15061

On Wed, 10 Sep 2003 20:43:25 +0800
"Richard Sydney-Smith" <richard@ibisaustralia.com> wrote:

> Tried to issue the command "vacum full" both from psql and the sql box in pgadmin without success.

seems like you also vacuumed the second 'U' out of the word :)


vacuum full;

does the trick.




cya
erik

-- 
Erik Thiele



From bruno@wolff.to Wed Sep  10 13:00:51 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 90DD8D1B504
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Sep 2003 13:00:51 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 54623-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Sep 2003 10:00:44 -0300 (ADT)
Received: from wolff.to (wolff.to [66.93.249.74])
	by svr1.postgresql.org (Postfix) with SMTP id 0E5CFD1B514
	for <pgsql-sql@postgresql.org>; Wed, 10 Sep 2003 10:00:40 -0300 (ADT)
Received: (qmail 25680 invoked by uid 500); 10 Sep 2003 13:07:09 -0000
Date: Wed, 10 Sep 2003 08:07:09 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: Richard Sydney-Smith <richard@ibisaustralia.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: how to vacum
Message-ID: <20030910130709.GB25627@wolff.to>
Mail-Followup-To: Richard Sydney-Smith <richard@ibisaustralia.com>,
	pgsql-sql@postgresql.org
References: <004001c37799$2367c250$7b6e32d2@athlon2000>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <004001c37799$2367c250$7b6e32d2@athlon2000>
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/82
X-Sequence-Number: 15060

On Wed, Sep 10, 2003 at 20:43:25 +0800,
  Richard Sydney-Smith <richard@ibisaustralia.com> wrote:
> Tried to issue the command "vacum full" both from psql and the sql box in pgadmin without success.
> 
> How do you use the command?
> 
> select vacum full; 
> 
> also does not work

Try using:
vacuum full
(Note that vacuum has 2 u's.)



From peter_e@gmx.net Wed Sep  10 19:46:54 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 9CF35D1B542
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Sep 2003 19:46:54 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 60671-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Sep 2003 16:46:45 -0300 (ADT)
Received: from mail.gmx.net (mail.gmx.de [213.165.64.20])
	by svr1.postgresql.org (Postfix) with SMTP id 5AAE2D1B522
	for <pgsql-sql@postgresql.org>; Wed, 10 Sep 2003 16:46:43 -0300 (ADT)
Received: (qmail 16088 invoked by uid 65534); 10 Sep 2003 19:46:44 -0000
Received: from dsl-082-082-167-029.arcor-ip.net (EHLO
	dsl-082-082-167-029.arcor-ip.net) (82.82.167.29)
	by mail.gmx.net (mp009) with SMTP; 10 Sep 2003 21:46:44 +0200
Date: Wed, 10 Sep 2003 21:46:43 +0200 (CEST)
From: Peter Eisentraut <peter_e@gmx.net>
X-X-Sender: peter@peter.localdomain
To: Richard Sydney-Smith <richard@ibisaustralia.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: how to vacum
In-Reply-To: <004001c37799$2367c250$7b6e32d2@athlon2000>
Message-ID: <Pine.LNX.4.44.0309102146270.1141-100000@peter.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/84
X-Sequence-Number: 15062

Richard Sydney-Smith writes:

> Tried to issue the command "vacum full" both from psql and the sql box in pgadmin without success.

vacuum full;
   ^^

-- 
Peter Eisentraut   peter_e@gmx.net




From martin@bugs.unl.edu.ar Wed Sep  10 20:46:02 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 18559D1B522
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Sep 2003 20:46:02 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 65316-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Sep 2003 17:45:32 -0300 (ADT)
Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208])
	by svr1.postgresql.org (Postfix) with ESMTP id CAEFDD1B52B
	for <pgsql-sql@postgresql.org>; Wed, 10 Sep 2003 17:45:29 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by bugs.unl.edu.ar (Postfix) with ESMTP
	id 20EA011DEE; Wed, 10 Sep 2003 17:39:22 -0300 (ART)
Received: from bugs.unl.edu.ar ([127.0.0.1])
	by localhost (bugs [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
	id 00991-05; Wed, 10 Sep 2003 17:39:21 -0300 (ART)
Received: from localhost (localhost [127.0.0.1])
	by bugs.unl.edu.ar (Postfix) with ESMTP
	id 8D4AB11DE1; Wed, 10 Sep 2003 17:39:20 -0300 (ART)
From: Martin Marques <martin@bugs.unl.edu.ar>
To: Bruno Wolff III <bruno@wolff.to>,
	Richard Sydney-Smith <richard@ibisaustralia.com>
Subject: Re: how to vacum
Date: Wed, 10 Sep 2003 17:39:17 -0300
User-Agent: KMail/1.5.3
Cc: pgsql-sql@postgresql.org
References: <004001c37799$2367c250$7b6e32d2@athlon2000>
	<20030910130709.GB25627@wolff.to>
In-Reply-To: <20030910130709.GB25627@wolff.to>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200309101739.17301.martin@bugs.unl.edu.ar>
X-Virus-Scanned: by amavisd-new-20030616-p3 (Debian) at unl.edu.ar
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/85
X-Sequence-Number: 15063

El Mi=E9 10 Sep 2003 10:07, Bruno Wolff III escribi=F3:
> On Wed, Sep 10, 2003 at 20:43:25 +0800,
>
>   Richard Sydney-Smith <richard@ibisaustralia.com> wrote:
> > Tried to issue the command "vacum full" both from psql and the sql box =
in
> > pgadmin without success.
> >
> > How do you use the command?
> >
> > select vacum full;
> >
> > also does not work
>
> Try using:
> vacuum full
> (Note that vacuum has 2 u's.)

When entering "vacum" to Dict, it catches nothing, but one of it's suggesti=
ons=20
is vacuum, which means "clean".

--=20
 17:38:01 up 19 days,  9:28,  3 users,  load average: 1.59, 1.39, 0.91
-----------------------------------------------------------------
Mart=EDn Marqu=E9s                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------