Merlin Moncure wrote:
 > On 3/1/07, Pavan Deolasee <pavan(dot)deolasee(at)enterprisedb(dot)com> 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

In response to

• Re: HOT - preliminary results at 2007-03-01 16:35:46 from Merlin Moncure

Responses

• Re: HOT - preliminary results at 2007-03-01 19:51:24 from Simon Riggs

pgsql-hackers by date

Next:	From: Jonathan Scher	Date: 2007-03-01 17:23:37
	Subject: Re: CLUSTER, using SHARE UPDATE EXCLUSIVE lock?
Previous:	From: Zoltan Boszormenyi	Date: 2007-03-01 16:58:52
	Subject: Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ?