PREPARE and EXPLAIN need to copy the source query just like we recently had to do in DECLARE CURSOR. AFAICS these are all the places affected. PREPARE case per example from Michael Fuhr, EXPLAIN case located by grepping for planner calls ...
Does this mean that cache lookup failures (most notably in pl/pgsql) will simply result in a replan as opposed to a query failure and the transaction being aborted? Or is this a first step in that direction? -sc
-- Sean Chittenden
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
