Merlin Moncure wrote: > On 3/1/07, Pavan Deolasee <[EMAIL PROTECTED]> wrote: >> > seems pretty solid except for one possible problem...at one point when > I dropped then later added the index on 'abalance', I got spammed > 'WARNING: found a HOT-updated tuple' from psql prompt.
Thats intentional. We don't yet support CREATE INDEX on a HOT-updated table. This is one of the major unfinished TODO items before we can consider patch feature complete. I have left the warning to catch this case till then. Thanks, Pavan ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings