Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id B3AE62E0050
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Tue, 10 Jun 2008 01:17:42 -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 03962-09
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Tue, 10 Jun 2008 01:17:27 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from wf-out-1314.google.com (wf-out-1314.google.com
 [209.85.200.168])
	by developer.postgresql.org (Postfix) with ESMTP id B4C282E004D
	for <pgsql-admin@postgresql.org>; Tue, 10 Jun 2008 01:17:25 -0300 (ADT)
Received: by wf-out-1314.google.com with SMTP id 25so2289969wfc.28
	for <pgsql-admin@postgresql.org>; Mon, 09 Jun 2008 21:17:24 -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:in-reply-to:mime-version:content-type:references;
	bh=D4XEDEGMhwT1PkCRNzgyVZOanTNoRGpBXnju+5eXX7Q=;
	b=D07kTr2GR2/Rtlj6tmw3ViD22uhOhBvm3gpjoeFPnlalaObDFAo4IRvTO4PL7BkCfv
	4A+nC8b0zw8gY0xtRLEZfvRznJQIJgnKftEVxJRfqLGq2gNkyq6tUWPB7jeqggClkXFf
	ViwFew/yU/nF1aJL0fg38diOPe/qXgFG26UMQ=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:in-reply-to:mime-version
	:content-type:references;
	b=LQ2BAj8K33BtFiuyZ82dtJxdzmHQCIzJ+04b9ylLTzNIeAycO6njHrZk5K3pBKnFeC
	hMls1Y7u9kFe4ad87LrZFVaxEcnjhVBF5qiwBmXgQMW3LN/ySgK88QSE6NgsTj0aUS7p
	Vs8Rhn31Et8H//pcfi3VX9a9HygRa9n9kF7yM=
Received: by 10.142.180.11 with SMTP id c11mr1816967wff.113.1213071444653;
	Mon, 09 Jun 2008 21:17:24 -0700 (PDT)
Received: by 10.142.211.2 with HTTP; Mon, 9 Jun 2008 21:17:24 -0700 (PDT)
Message-ID: <2267dd9e0806092117sda112dt8ac2f2ba8ed5e66f@mail.gmail.com>
Date: Tue, 10 Jun 2008 12:17:24 +0800
From: "Tommy Cheng" <csckcac@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: turn off auto index for foreign key
In-Reply-To: <dcc563d10806092050y3f41ef00j95390d335e4d11c0@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1343_31016898.1213071444671"
References: <2267dd9e0806091948k24a46cegcd45e65a5aa632ed@mail.gmail.com>
	<dcc563d10806092050y3f41ef00j95390d335e4d11c0@mail.gmail.com>
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/64
X-Sequence-Number: 29402

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

you are right. I double checked. So, is there any way to turn off auto index
creation for the parent? (the best is changing postgresql database setting)
I am using postgres (PostgreSQL) 8.1.9 on CentOS 5 x86_64

On Tue, Jun 10, 2008 at 11:50 AM, Scott Marlowe <scott.marlowe@gmail.com>
wrote:

> On Mon, Jun 9, 2008 at 8:48 PM, Tommy Cheng <csckcac@gmail.com> wrote:
> > 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?
>
> There is no auto index creation for child relationships, only for the
> parent (unique index for primary key etc)
>

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

you are right. I double checked. So, is there any way to turn off auto index creation for the parent? (the best is changing postgresql database setting)<br>I am using postgres (PostgreSQL) 8.1.9 on CentOS 5 x86_64<br><br><div class="gmail_quote">
On Tue, Jun 10, 2008 at 11:50 AM, Scott Marlowe &lt;<a href="mailto:scott.marlowe@gmail.com">scott.marlowe@gmail.com</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div class="Wj3C7c">On Mon, Jun 9, 2008 at 8:48 PM, Tommy Cheng &lt;<a href="mailto:csckcac@gmail.com">csckcac@gmail.com</a>&gt; wrote:<br>
&gt; Hi admins,<br>
&gt; &nbsp; I would like to turn off the auto index for child table&#39;s foreign key. It<br>
&gt; is because i want to read the information_schema for table, column, index,<br>
&gt; unique and so on after creating the database. How to turn off the auto<br>
&gt; behavior? Or Is there a way to distinguish between auto one and user created<br>
&gt; index?<br>
<br>
</div></div>There is no auto index creation for child relationships, only for the<br>
parent (unique index for primary key etc)<br>
</blockquote></div><br>

------=_Part_1343_31016898.1213071444671--