On Fri, 2005-07-22 at 09:40 -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > In general, the hint bits are good. In *some* cases, not. I still seek > > control over that as a designer.
... > ... not be worth > solving with a knob as klugy and potentially dangerous as > suppress_hint_bits. I note that heap_get_latest_tid() relies upon the setting of HEAP_XMIN_COMMITTED in the infomask in lieu of checking any return codes from the HeapTupleSatisfies check. Sequences also touch on that. I agree with you that it is potentially dangerous to mess with that, for now. I'll look at Read-Only Tables for 8.2 rather than this quick-fix. Best Regards, Simon Riggs ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match