From: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: partial index on non default tablespace syntax |
Date: | 2005-06-19 06:21:02 |
Message-ID: | a97c7703050618232119d5fe89@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)fuhr(dot)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/
>
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2005-06-19 08:48:12 | Re: [SQL] Set Membership operator -- test group membership |
Previous Message | Tom Lane | 2005-06-18 17:40:37 | Re: partial index on non default tablespace syntax |