Re: Query hangs when getting too complex...

Paulo Jan <admin@mail.ddnet.es> writes:
>     Here it is, but it looks the same to me:

No, it's not the same at all...

> #0  0x80d58d7 in pprint ()
> #1  0x80fc729 in pg_parse_and_rewrite ()
> #2  0x80fc9a1 in pg_exec_query_string ()
> #3  0x80fdab6 in PostgresMain ()

[ eyeballs pprint ]  Oh my.  Nothing like a fixed-size buffer to blow up
on you :-(.  pprint will crash and burn if indentLev exceeds 80/3, and
I'll bet that's exactly what's happening on your complex query.  Wonder
why no one noticed this before?

Try turning down your debug level so that the detailed query plan
doesn't get dumped.  In the meantime, I'll do something to fix this
for 7.2.

            regards, tom lane