On Fri, 2005-11-18 at 00:15 +0000, Simon Riggs wrote:
> Minor comment update.
Applied with adjustments.
BTW, I noticed the following comment a few lines down in execMain.c
(circa line 1564):
* note: we can't run UPDATE queries with transactions
* off because UPDATEs are actually INSERTs and our
* scan will mistakenly loop forever, updating the tuple
* it just inserted.. This should be fixed but until it
* is, we don't want to get stuck in an infinite loop
* which corrupts your database..
This seems obsolete; I'll remove it shortly barring any objections.
-Neil
---------------------------(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
