"Tom Lane" <[EMAIL PROTECTED]> wrote: > Joe Conway <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
