Re: Tablespace issues (comment on ,moving indexes)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Brown <kevin(at)sysexperts(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tablespace issues (comment on ,moving indexes)
Date: 2004-08-10 00:22:11
Message-ID: 22138.1092097331@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Kevin Brown <kevin(at)sysexperts(dot)com> writes:
> Tom Lane wrote:
>> 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...

[ shrug ] There have been some variants of ALTER TABLE that would work
on indexes since day one. Sequences too.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2004-08-10 00:23:55 Re: fsync vs open_sync
Previous Message Manfred Koizar 2004-08-10 00:13:33 Re: Updateable Views?