Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 3DCAF2E0054 for ; Sun, 13 Apr 2008 11:25:59 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84259-01 for ; Sun, 13 Apr 2008 11:25:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail63.csoft.net (leary.csoft.net [205.205.214.5]) by developer.postgresql.org (Postfix) with SMTP id 5FEB22E002E for ; Sun, 13 Apr 2008 11:25:56 -0300 (ADT) Received: (qmail 3089 invoked by uid 1112); 13 Apr 2008 14:25:54 -0000 Date: Sun, 13 Apr 2008 10:25:54 -0400 (EDT) From: Kris Jurka X-X-Sender: books@leary.csoft.net To: =?ISO-8859-15?Q?Alexander_W=F6hrer?= cc: pljava-dev@pgfoundry.org, pgsql-hackers@postgresql.org Subject: Re: [Pljava-dev] stack depth limit exceeded - patch possible? In-Reply-To: <48010499.30000@par.univie.ac.at> Message-ID: References: <48010499.30000@par.univie.ac.at> MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN; format=flowed Content-Transfer-Encoding: QUOTED-PRINTABLE X-Archive-Number: 200804/901 X-Sequence-Number: 116994 On Sat, 12 Apr 2008, Alexander W=F6hrer wrote: > I'm working on Windows XP SP2 (stack limit 3500 kb) and deployed > successfully my application (doing some external Web service calling) > inside PostGre 8.3.0. > > Unfortunatelly, the application needs at least 3 Threads and will run > for quite some time. > > I found this comment > > http://pgfoundry.org/pipermail/pljava-dev/2005/000491.html > > by Thomas Hallgren where he mentioned that PostGre only defines > one stack and therefor pl/java has no way of telling PostGre > about multiple thread stack pointers. > > My question is now if there is a patched version available of PostGre > 8.3.0 having this stack_depth check disabled? This was fixed in postgresql/pljava shortly after the referenced=20 discussion. As requested, postgresql 8.1+ allows modification of=20 stack_base_ptr so pljava can set it as desired. Kris Jurka=