On 10/16/07, Pavel Stehule <[EMAIL PROTECTED]> wrote: > please, read: > http://www.pgsql.cz/index.php/Automatic_execution_plan_caching_in_PL/pgSQL >
Thanks Pavel, I actually came across that wiki article via Google when I was first trying to learn more about the message. But, I'm not asking for help understanding how plan caching works. As mentioned, I've already fixed the problem with my function. Rather, I'm suggesting that we increase the helpfulness of the error message. BJ ---------------------------(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