Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id DA96F9FB6EF
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 14 Mar 2007 10:12:26 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 87103-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 14 Mar 2007 10:12:16 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210])
	by postgresql.org (Postfix) with ESMTP id D3CE49FB2F8
	for <pgsql-sql@postgresql.org>; Wed, 14 Mar 2007 10:12:16 -0300 (ADT)
Received: from host3.dynacom.ondsl.gr ([62.103.35.211]
 helo=ip216.internal.net)
	by matrix.gatewaynet.com with esmtp (Exim 4.62)
	(envelope-from <achill@matrix.gatewaynet.com>) id 1HRTH3-0001Cl-Mk
	for pgsql-sql@postgresql.org; Wed, 14 Mar 2007 15:12:13 +0200
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-sql@postgresql.org
Subject: Re: reindex database
Date: Wed, 14 Mar 2007 15:12:05 +0200
User-Agent: KMail/1.9.3
References: <et8qnr$pvk$1@news.hub.org>
In-Reply-To: <et8qnr$pvk$1@news.hub.org>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-7"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200703141512.10225.achill@matrix.gatewaynet.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/193
X-Sequence-Number: 27831

=D3=F4=E9=F2 =D4=E5=F4=DC=F1=F4=E7 14 =CC=DC=F1=F4=E9=EF=F2 2007 14:44, =EF=
/=E7 Sabin Coanda =DD=E3=F1=E1=F8=E5:
> Hi,
>
> It would be so nice to use REINDEX DATABASE command without name, for the
> current database.
> Now the command is useless when a database schema script refers just
> itself, and the database name is not establish. I have to use REINDEX TAB=
LE
> name instead searching all the database tables.
>
> What is your opinion ?

<path to your db sources>/contrib/reindexdb/reindexdb -a
reindexes everything.

Also your script would do a

#!/bin/csh
set mydb=3D`psql -q -t -c "SELECT current_database()" | tr -d " \n"`
<path to your db sources>/contrib/reindexdb/reindexdb -d $mydb

>
> Regards,
> Sabin
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

=2D-=20
Achilleas Mantzios