Re: ALTER TABLE TODO items

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER TABLE TODO items
Date: 2004-05-06 16:18:47
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB34101AE0A@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> I tweaked things so that the clustered flag is preserved for indexes
> that aren't directly affected by the ALTER TYPE. It would take more
> work to preserve the setting for an index that is rebuilt by ALTER
TYPE,
> and I'm not even sure that it's sensible --- the new index could have
> a significantly different ordering from the old. What do you think?

Fair enough. Perhaps a notice level log message would be appropriate?

Merlin

Browse pgsql-hackers by date

  From Date Subject
Next Message sdv mailer 2004-05-06 16:19:56 Re: PostgreSQL pre-fork speedup
Previous Message Bruce Momjian 2004-05-06 16:17:38 Re: alter table alter columns vs. domains