From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | USING INDEX TABLESPACE |
Date: | 2004-07-28 04:10:47 |
Message-ID: | 41072747.8030602@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
The attached patch allows the specification of the tablespace the index
is to be created in for unique and pk constraints. It also fixes the
dumping of such constraints so that they are restored into the correct
tablespace, after they have been moved with SET TABLESPACE. This is
currently an outstanding pg_dump bug.
The syntax is exactly what Oracle uses as far as i can tell, and I think
that we need 'using index' in there, because it's the index that's in a
tablespace, NOT the constraint itself.
Includes docs.
eg:
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;
Chris
Attachment | Content-Type | Size |
---|---|---|
conspc.txt.gz | application/x-gzip | 3.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2004-07-28 04:38:34 | Re: casting strings to multidimensional arrays yields strange |
Previous Message | Tom Lane | 2004-07-27 18:06:58 | Re: [subxacts] Fixing TODO items |