Re: Tablespace issues (comment on ,moving indexes)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tablespace issues (comment on ,moving indexes)
Date: 2004-08-09 20:36:02
Message-ID: 19524.1092083762@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-09 21:01:47 Re: fsync vs open_sync
Previous Message Hicham G. Elmongui 2004-08-09 20:23:37 am i asking in the wrong place?