Gregory Stark wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:

Couldn't we just have it pay attention to the existing
Recursive query does not consume stack. The server enters an infinite
loop without consuming stack. Stack-depth error does not happen.
We could have a separate guc variable which limits the maximum number of
levels of recursive iterations. That might be a useful feature for DBAs that
want to limit their users from issuing an infinite query.
statement_timeout :)

Good point.

Though it occurs to me that if you set FETCH_COUNT in psql (or do the
equivalent in your code ) statement_timeout becomes much less useful.

i don't think statement_timeout is a good idea at all.
it is not deterministic. depending on the load on the server some queries will execute while others fail.
a separate GUC is needed.

   best regards,


Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340,

Sent via pgsql-patches mailing list (
To make changes to your subscription:

Reply via email to