Re: recursive text construction in plpgsql? - Mailing list pgsql-general

From Tom Lane
Subject Re: recursive text construction in plpgsql?
Date
Msg-id 19190.999917193@sss.pgh.pa.us
Whole thread Raw
In response to Re: recursive text construction in plpgsql?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I said:
> Frank Miles <fpm@u.washington.edu> writes:
>> The simple recursive function:
>> [ doesn't work ]

> Looks like you have found a real bug, but I don't know what it is yet...

Now I do :-(.  FunctionCache needs to be a read-only data structure;
it can't contain the argument block that's built for an individual call,
because the same expression tree might be invoked recursively while
filling in the arguments for a function.  I'm surprised no one has
noticed this before.

I'll fix it for 7.2...

            regards, tom lane

pgsql-general by date:

Previous
From: David Ford
Date:
Subject: Re: Problem w/ dumping huge table and no disk space
Next
From:
Date:
Subject: Temp Table In SQL Function