Re: Tablespace issues (comment on ,moving indexes) - Mailing list pgsql-hackers

From Kevin Brown
Subject Re: Tablespace issues (comment on ,moving indexes)
Date
Msg-id 20040809214633.GC2544@filer
Whole thread Raw
In response to Re: Tablespace issues (comment on ,moving indexes)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Tablespace issues (comment on ,moving indexes)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Tablespace issues (comment on ,moving indexes)  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tom Lane wrote:
> Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> > 1. there is no COMMENT ON TABLESPACE support
> 
> That's right.
> 
> > 2. how is one supposed to move indexes(not tables) to another tablespace?
> 
> Use ALTER TABLE on the index.

Hmm...not ALTER INDEX?  Now that there's an operation that actually
modifies an index instead of the table itself, should there be an ALTER
INDEX?  It would be cleaner and more consistent, IMO...


-- 
Kevin Brown                          kevin@sysexperts.com


pgsql-hackers by date:

Previous
From: pgsql@mohawksoft.com
Date:
Subject: Re: fsync vs open_sync
Next
From: Bruce Momjian
Date:
Subject: Re: Beta Leader?