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 <[EMAIL PROTECTED]> wrote:
> On Sat, Jun 18, 2005 at 10:24:06PM +0530,
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> Looks like its not possible to specify tablespace of an index with a
> where clause,
Hm?
regression=# create table foo(f1 int, f2 int);
CREATE TABLE
regression=# create index fooi on foo (f1) tablespace pg_default where f2 < 0;
CREATE INDEX
(I ha
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 wha
