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,
Hi,
Looks like its not possible to specify tablespace of an index with a
where clause,
we require to create the index, and then use ALTER INDEX for setting
the tablespace. Is it something that is already known or its itentional so as
to keep the command unambigious. i also could not find it in
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
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 hadn't