PGSQL COMMITTERS 34 RE PGSQL PREPARE AND EXPLAIN NEED TO COPY THE SOURCE QUERY JUST LIKE WE
From: sean@no-spam (Sean Chittenden)
Subject: Re: pgsql: PREPARE and EXPLAIN need to copy the source query just like we
Date: Sun, 12 Dec 2004 15:18:54 -0800


> 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