Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 2617563623B
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 11 Mar 2010 11:21:31 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 07114-06-4 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 11 Mar 2010 15:21:20 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ew0-f220.google.com (mail-ew0-f220.google.com
	[209.85.219.220])
	by mail.postgresql.org (Postfix) with ESMTP id 7D759636071
	for <pgsql-sql@postgresql.org>; Thu, 11 Mar 2010 11:20:46 -0400 (AST)
Received: by ewy20 with SMTP id 20so75858ewy.21
	for <pgsql-sql@postgresql.org>; Thu, 11 Mar 2010 07:20:44 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:content-type;
	bh=huWYGIPViHmyoLZJFm+MayWPITgkabWmCrA/pa5Udek=;
	b=jFuZ+7qBXC9YYwzb78B+7H6i5r8ys1VP877D1Vyhkv9+crvH2WcdKebMZAqiacia1g
	vJOUs8SoSQS/w94p0KAqVb23s6vqZe3UMlqeuUJhGB7niuwin0yRjMcKpN8p/DKW29ci
	QevAhklzBUG8rr5PXmZWswqG1qce1DvNmiuIU=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:content-type;
	b=c7lDLvXbc+7J5+JgHbt8iaTkgs53zyTwiLlP3/RHJlCybndVSKmyMi7jbcL/nENU2M
	tdXsSOfusRhJ67ut0t8cJu3dGp5MEsv84T4CMhKOZu0/nsKmHmzdTv/jlQa5wTqxaqQM
	OK63zQatuixuQRhuEtOZ6FV49eX6w/In1voRc=
MIME-Version: 1.0
Received: by 10.103.4.9 with SMTP id g9mr307778mui.57.1268320844209; Thu, 11
	Mar 2010 07:20:44 -0800 (PST)
In-Reply-To: <b4399d111003110715h1415e094paaf0d5e5e0ada46@mail.gmail.com>
References: <b4399d111003110715h1415e094paaf0d5e5e0ada46@mail.gmail.com>
Date: Thu, 11 Mar 2010 18:20:44 +0300
Message-ID: <b4399d111003110720m4805d511pb468aefb0f3cd60c@mail.gmail.com>
Subject: Re: Selecting names of indexes that are not dependent on constraints.
From: Dmitriy Igrishin <dmitigr@gmail.com>
To: postgres list <pgsql-sql@postgresql.org>
Content-Type: multipart/alternative; boundary=001636426679615f5e048187f583
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.739 tagged_above=-10 required=5
	tests=BAYES_20=-0.74, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/58
X-Sequence-Number: 33765

--001636426679615f5e048187f583
Content-Type: text/plain; charset=ISO-8859-1

Of course, I meant the indexes of which constraints do not depend. :)

2010/3/11 Dmitriy Igrishin <dmitigr@gmail.com>

> Hey all,
>
> How can I select names of indexes of table (or even whole schema) that are
> not dependent on constraints?
>
> Unfortunately there is no way to select only "independent" indexes from
> pg_indexes view.
>
> How can I do it?
>
> Regards,
> Dmitriy Igrishin
>

--001636426679615f5e048187f583
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Of course, I meant the indexes of which constraints do not depend. :)<br><b=
r><div class=3D"gmail_quote">2010/3/11 Dmitriy Igrishin <span dir=3D"ltr">&=
lt;<a href=3D"mailto:dmitigr@gmail.com">dmitigr@gmail.com</a>&gt;</span><br=
><blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204,=
 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hey all,<br><br>How can I select names of indexes of table (or even whole s=
chema) that are not dependent on constraints?<br><br>Unfortunately there is=
 no way to select only &quot;independent&quot; indexes from pg_indexes view=
.<br>

<br>How can I do it?<br><br>Regards,<br><font color=3D"#888888">Dmitriy Igr=
ishin<br>
</font></blockquote></div><br>

--001636426679615f5e048187f583--