Re: Query hangs when getting too complex... - Mailing list pgsql-general

From Tom Lane
Subject Re: Query hangs when getting too complex...
Date
Msg-id 1996.1008788201@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query hangs when getting too complex...  (Paulo Jan <admin@digital.ddnet.es>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can't use subselect in check constraint
Next
From: "Ian Harding"
Date:
Subject: How Many Years have Passed?