Tom Lane wrote:
> Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)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(at)sysexperts(dot)com