Re: lots of values for IN() clause

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Markus Schiltknecht <markus(at)bluegap(dot)ch>
Cc: Richard Huxton <dev(at)archonet(dot)com>, Shelby Cain <alyandon(at)yahoo(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: lots of values for IN() clause
Date: 2006-11-02 16:20:26
Message-ID: 20061102162026.GD2516@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 02, 2006 at 05:16:40PM +0100, Markus Schiltknecht wrote:
> OTOH, having to configure such things is not exactly user friendly. I
> guess it's difficult to determine the stack limit in a cross-platform
> way. Or does having that configuration option other reasons for existence?

A patch went in recently that (on platforms where it's possible) tries
to determine the maximum stack depth and complains if you set it too
large. So this problem should go away in the future...

There might be situations where you want to be able to use a larger
stack, that's why it's configurable. PostgreSQL now actually checks
whether the number you provided makes sense.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-11-02 16:21:51 Re: Weird double single quote issue
Previous Message Markus Schiltknecht 2006-11-02 16:16:40 Re: lots of values for IN() clause