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] ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match