Re: partial index on non default tablespace syntax

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: partial index on non default tablespace syntax
Date: 2005-06-18 17:27:22
Message-ID: 20050618172722.GA92486@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-06-18 17:40:37 Re: partial index on non default tablespace syntax
Previous Message Rajesh Kumar Mallah 2005-06-18 16:54:06 partial index on non default tablespace syntax