Stack depth exceeded error

From: Suresh <suiyengar(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Stack depth exceeded error
Date: 2008-05-12 13:05:08
Message-ID: 808226.554.qm@web54502.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

I have custom postgres code. I get the error below for the query

"select l_orderkey as a from tpcd.orders, tpcd.lineitem where o_orderkey=l_orderkey and l_partkey<100 and l_linestatus='F';"

ERROR: stack depth limit exceeded
HINT: Increase the configuration parameter "max_stack_depth".

However, the same code runs fine with one condition in where clause, but fails with the error above in case of multiple conditions.

Whats the cause of this error ? I tried increasing the stack limit; but it doesnt help.

--
Suresh Iyengar


---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2008-05-12 13:49:55 Re: Stack depth exceeded error
Previous Message Zdenek Kotala 2008-05-12 12:22:11 Re: bloated heapam.h