Re: max length of sql select statement ?

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: markus brosch <brosch(at)gmx(dot)de>
Cc: mallah(at)trade-india(dot)com, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: max length of sql select statement ?
Date: 2003-07-09 13:29:58
Message-ID: 1057757398.46100.63.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> Maybe we can disuss that problem here again?! What exactly means
> "max_expr_depth"? Thanks for any help

If I'm not mistaken, max_expr_depth is used to catch runaway recursion
(view a is select * from b, view b is select * from a).

It's a tunable in postgresql.conf. Toss a couple of 0's behind the
number and uncomment the line.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Yasir Malik 2003-07-09 15:07:48 Re: Need help with complex query
Previous Message Achilleus Mantzios 2003-07-09 12:16:31 Re: Logging select statements