Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 615A82E005E
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Mon,  9 Jun 2008 23:48:13 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 52132-04
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Mon,  9 Jun 2008 23:48:04 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.232])
	by developer.postgresql.org (Postfix) with ESMTP id 128B62E0056
	for <pgsql-admin@postgresql.org>; Mon,  9 Jun 2008 23:48:09 -0300 (ADT)
Received: by rv-out-0506.google.com with SMTP id b25so2874449rvf.43
	for <pgsql-admin@postgresql.org>; Mon, 09 Jun 2008 19:48:08 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=IhLi0IV8NYEL3pFpBOdYHJCNhL6L+nFpSnVmhddCNs0=;
	b=NexrrUhQwhnqEBsFSn64XHhNplP69vvhrduejT1D0jo9cZkxICYcv48TKIGBef4Hvo
	k5wq04AvE9IvIsX0vPlMYoGHQumnmBtxci7+4sdWh4Xa3p+WEUBxIZaMrD5d9rZXirbl
	aBNblLrRBI6ZHSALQ8qKNNvRz1vZnV0vlx1Mc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=E0BOTmizEVBPhb1+6PEIeNc0xGUxDCCzFCIO27hztci6AWgL9LPlDvene10K6f6VO6
	zJDfW+mbY4xx541KPkt9u3sFhrfEmlEbwTN8D5h2Sy8PuL3hVBFwiOGcvuUGLiOUp53y
	3/QYosJxjmmtHv77vI3gTPUOWFlEeto24EaJ4=
Received: by 10.142.142.14 with SMTP id p14mr1786875wfd.139.1213066088658;
	Mon, 09 Jun 2008 19:48:08 -0700 (PDT)
Received: by 10.142.211.2 with HTTP; Mon, 9 Jun 2008 19:48:08 -0700 (PDT)
Message-ID: <2267dd9e0806091948k24a46cegcd45e65a5aa632ed@mail.gmail.com>
Date: Tue, 10 Jun 2008 10:48:08 +0800
From: "Tommy Cheng" <csckcac@gmail.com>
To: pgsql-admin@postgresql.org
Subject: turn off auto index for foreign key
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1176_17570322.1213066088653"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200806/62
X-Sequence-Number: 29400

------=_Part_1176_17570322.1213066088653
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi admins,
  I would like to turn off the auto index for child table's foreign key. It
is because i want to read the information_schema for table, column, index,
unique and so on after creating the database. How to turn off the auto
behavior? Or Is there a way to distinguish between auto one and user created
index?
  Thanks
Tommy Cheng

------=_Part_1176_17570322.1213066088653
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi admins,<br>&nbsp; I would like to turn off the auto index for child table&#39;s foreign key. It is because i want to read the information_schema for table, column, index, unique and so on after creating the database. How to turn off the auto behavior? Or Is there a way to distinguish between auto one and user created index?<br>
&nbsp; Thanks<br>Tommy Cheng <br>

------=_Part_1176_17570322.1213066088653--