Skip site navigation (1) Skip section navigation (2)

USING INDEX TABLESPACE

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 (view raw or flat)
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: conspc.txt.gz
Description: application/x-gzip (3.8 KB)

Responses

pgsql-patches by date

Next:From: Joe ConwayDate: 2004-07-28 04:38:34
Subject: Re: casting strings to multidimensional arrays yields strange
Previous:From: Tom LaneDate: 2004-07-27 18:06:58
Subject: Re: [subxacts] Fixing TODO items

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group