Re: [PATCHES] USING INDEX TABLESPACE

[Christopher Kings-Lynne]

create table test (a integer primary key index tablespace loc);

create table test (a integer unique index tablespace loc);

create table test (a integer);
alter table test add primary key(a) index tablespace loc;

create table test (a integer);
alter table test add unique(a) index tablespace loc;

Crap!

I left out the word 'using' on all those examples :/

create table test (a integer primary key using index tablespace loc);

create table test (a integer unique using index tablespace loc);

create table test (a integer);
alter table test add primary key(a) using index tablespace loc;

create table test (a integer);
alter table test add unique(a) using index tablespace loc;

Chris

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly