Re: concat_ws

"Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> Joe Conway <mail@joeconway.com> writes:
> > Tom Lane wrote:
> >> It seems to be running out of memory.
>
> > Also worth noting, without STRICT, even a plain EXPLAIN *without*
> > ANALYZE causes the problem to show itself.
>
> Yeah.  The problem is that the SQL function inliner generates an
> enormous expression tree from this function definition.  7.3 had no
> inliner so no problem.
>
> I am not sure what to do about it --- the only idea that comes to mind
> is to put an arbitrary limit (of, say, 5 or 10 function calls) on the
> depth of inlining expansion.  That seems like a pretty ugly answer
> ... anyone have a better one?

Please no one tell to add another ugly parameter on postgresql.conf

My cent.

Regards
Gaetano Mendola