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 <[email protected]>)
Responses Re: Tablespace issues (comment on ,moving indexes)
Re: Tablespace issues (comment on ,moving indexes)
List pgsql-hackers
Tom Lane wrote:
> Stefan Kaltenbrunner <[email protected]> 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                          [email protected]


pgsql-hackers by date:

Previous
From: [email protected]
Date:
Subject: Re: fsync vs open_sync
Next
From: Bruce Momjian
Date:
Subject: Re: Beta Leader?