"Eric Worden" writes:
> Thank you this helped me fix it. I moved the "create temporary
> table..." statement to the outermost calling function and changed it
> from STABLE to VOLATILE. I'm not sure which change made the
> difference -- I had to move the create table statement for an
> additional
Thank you this helped me fix it. I moved the "create temporary
table..." statement to the outermost calling function and changed it
from STABLE to VOLATILE. I'm not sure which change made the
difference -- I had to move the create table statement for an
additional reason.
On Sat, Dec 27, 2008
Eric Worden wrote:
> The recursive function creates a temp table [...] I
> have version 8.1.10.
While I haven't looked in detail, I'd be surprised if this wasn't an
issue with pre-8.3 versions lack of any way to automatically re-generate
cached plans in functions.
Try running your code on an 8.
Hello, I'm guessing the rows aren't really disappearing but how else
to describe it?
I have a trigger function that calls another function that is
recursive. The recursive function creates a temp table and inserts
rows into it. After the recursive function returns, the trigger
function exam
