Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 4487C2E0058 for ; Tue, 10 Jun 2008 00:50:38 -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 54897-09 for ; Tue, 10 Jun 2008 00:50:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.183]) by developer.postgresql.org (Postfix) with ESMTP id 1396C2E0032 for ; Tue, 10 Jun 2008 00:50:04 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id n4so1993667wag.5 for ; Mon, 09 Jun 2008 20:50:03 -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:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=HjTiM8Ghn4pA2VhkVPJOnCLpBjKyDs+dVLYVSgjS0WQ=; b=pJj+tCmuo5+avW8uWZlnQsfNxrTuAWcugCkg6rCDCME0a/YhwiqbJRRNEqzIHD0Y6L bjt2HIGq4RAY4dUfgLjzc4zP7QWDfwkTSE7MAmVu+6F9fKCzf+K2rNWrCR392SerrZZV IwettGvIOzkSyzLHQP++QshVuuq3MGe6wsLNE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=Ul+/WlIYXkPS1zb+w+KznBEarPrBSy6Xwa7yGMmtAiGYhyfLITz3jExvd/b1eDXZDQ SYgAfnMLnnf4WiVz+tmUwRS/J48UOEB/mUW14o78HsOQQgQVTyhm2Wp7OsP8vusHEfY9 8yHDXZVZbdR+6nz0KAeQHzA4pc/u2kftnf2ho= Received: by 10.114.255.1 with SMTP id c1mr4302215wai.143.1213069803399; Mon, 09 Jun 2008 20:50:03 -0700 (PDT) Received: by 10.114.130.17 with HTTP; Mon, 9 Jun 2008 20:50:03 -0700 (PDT) Message-ID: Date: Mon, 9 Jun 2008 21:50:03 -0600 From: "Scott Marlowe" To: "Tommy Cheng" Subject: Re: turn off auto index for foreign key Cc: pgsql-admin@postgresql.org In-Reply-To: <2267dd9e0806091948k24a46cegcd45e65a5aa632ed@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <2267dd9e0806091948k24a46cegcd45e65a5aa632ed@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/63 X-Sequence-Number: 29401 On Mon, Jun 9, 2008 at 8:48 PM, Tommy Cheng 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)