X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id B55655283A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 18 Jun 2005 14:27:37 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 08765-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 18 Jun 2005 17:27:27 +0000 (GMT)
Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158])
	by svr1.postgresql.org (Postfix) with ESMTP id 6A32752836
	for <pgsql-sql@postgresql.org>; Sat, 18 Jun 2005 14:27:26 -0300 (ADT)
Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1])
	by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j5IHRNr9071534
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK);
	Sat, 18 Jun 2005 11:27:25 -0600 (MDT)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: from winnie.fuhr.org (localhost [127.0.0.1])
	by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j5IHRMno092548;
	Sat, 18 Jun 2005 11:27:22 -0600 (MDT)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: (from mfuhr@localhost)
	by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j5IHRMp5092547;
	Sat, 18 Jun 2005 11:27:22 -0600 (MDT) (envelope-from mfuhr)
Date: Sat, 18 Jun 2005 11:27:22 -0600
From: Michael Fuhr <mike@fuhr.org>
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: partial index on non default tablespace syntax
Message-ID: <20050618172722.GA92486@winnie.fuhr.org>
References: <a97c7703050618095412321ec1@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <a97c7703050618095412321ec1@mail.gmail.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200506/224
X-Sequence-Number: 21825

On Sat, Jun 18, 2005 at 10:24:06PM +0530, Rajesh Kumar Mallah wrote:
> 
> Looks like its not possible to specify tablespace of an index with a
> where clause,

Could you show the command you're running and the error you get,
or otherwise explain what problem you're seeing?  Is the following
not what you're looking for?

CREATE INDEX foo_name_idx ON foo (name)
  TABLESPACE testspace
  WHERE name IS NOT NULL;

http://www.postgresql.org/docs/8.0/static/sql-createindex.html

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/