Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 55FDA9FB1CD
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 16 Jan 2007 09:52:13 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 86045-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 16 Jan 2007 09:51:59 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from web30001.mail.mud.yahoo.com (web30001.mail.mud.yahoo.com
	[209.191.69.18]) by postgresql.org (Postfix) with SMTP id CD54A9FB1CC
	for <pgsql-sql@postgresql.org>; Tue, 16 Jan 2007 09:51:59 -0400 (AST)
Received: (qmail 34565 invoked by uid 60001); 16 Jan 2007 13:51:57 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=ETfuXfZ4muMzierrIQDxD+neevACYmKpfw3jmSXMNfCv2TMwY/nXfH+J5D+PkCb/ZwrG5k5vGPxyVAVOgjrUhOG26jP8mocL74riDFFG9t9D3QMQm/XNF6N72EB8QqHLayWGpOF2g1miitrGQGZuU/1Xhrc9YyrgxhJ9U/vC2gs=;
X-YMail-OSG: 
 dkGMlaYVM1lG4JZ4GgjVo605vIADj5uOfrfEJ9zySo2LFnPetLwOxmzYBSIBtsDGGnxfxNgBMWrtrkRMlO4uoug6SlPLSrG8Ng3oBHKkH_OPWxeJY6edn8ARtTZttvP_NUCmjMX9BJ_e6mA-
Received: from [200.161.5.135] by web30001.mail.mud.yahoo.com via HTTP;
	Tue, 16 Jan 2007 05:51:57 PST
X-Mailer: YahooMailRC/368.3 YahooMailWebService/0.6.132.7
Date: Tue, 16 Jan 2007 05:51:57 -0800 (PST)
From: Mario Behring <mariobehring@yahoo.com>
Subject: Droping indexes
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1934118592-1168955517=:33764"
Message-ID: <726736.33764.qm@web30001.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/52
X-Sequence-Number: 27204

--0-1934118592-1168955517=:33764
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi all,=0A=0APlease, if I drop all indexes from a table, can I recreate the=
m after performing a vacuum full at this table? I mean, I do not know detai=
ls about the indexes, so what I am asking is if I issue a REINDEX on this t=
able, will it  create the proper indexes again?=0A=0APlease advise.=0A=0ATh=
anks in advance.=0A=0AMario Behring=0A=0A=0A=0A=0A =0A_____________________=
_______________________________________________________________=0ANever mis=
s an email again!=0AYahoo! Toolbar alerts you the instant new Mail arrives.=
=0Ahttp://tools.search.yahoo.com/toolbar/features/mail/
--0-1934118592-1168955517=:33764
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:arial,helvetica,sans-serif;font-size:10p=
t"><div>Hi all,<br><br>Please, if I drop all indexes from a table, can I re=
create them after performing a vacuum full at this table? I mean, I do not =
know details about the indexes, so what I am asking is if I issue a REINDEX=
 on this table, will it&nbsp; create the proper indexes again?<br><br>Pleas=
e advise.<br><br>Thanks in advance.<br><br>Mario Behring<br></div></div><br=
>=0A=09=0A=0A=0A=0A <hr size=3D1>Looking for earth-friendly autos? <br> <a =
href=3D"http://autos.yahoo.com/green_center/;_ylc=3DX3oDMTE4MGw4Z2hlBF9TAzk=
3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDZ3JlZW5jZW50ZXI-">Browse Top Cars by "Gree=
n Rating"</a> at Yahoo! Autos' Green Center.  </body></html>
--0-1934118592-1168955517=:33764--