From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: partial index on non default tablespace syntax
Date: Sun, 19 Jun 2005 11:51:02 +0530
Message-ID: <a97c7703050618232119d5fe89@mail.gmail.com> (raw)
In-Reply-To: <20050618172722.GA92486@winnie.fuhr.org>
References: <a97c7703050618095412321ec1@mail.gmail.com>
<20050618172722.GA92486@winnie.fuhr.org>
Fuhr,Tom and Everyone
Extremely sorry for not consulting the docs.
I was doing this:
CREATE INDEX foo_name_idx ON foo (name)
WHERE name IS NOT NULL TABLESPACE testspace ;
Regds
Rajesh Kumar Mallah.
On 6/18/05, Michael Fuhr <mike@fuhr.org> wrote:
> 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/
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah.rajesh@gmail.com, mike@fuhr.org
Subject: Re: partial index on non default tablespace syntax
In-Reply-To: <a97c7703050618232119d5fe89@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox