Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 0ECF19FAE4E
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  8 Feb 2007 13:42:23 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 21306-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  8 Feb 2007 13:42:13 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.229])
	by postgresql.org (Postfix) with ESMTP id C4BFA9FA354
	for <pgsql-sql@postgresql.org>; Thu,  8 Feb 2007 13:42:12 -0400 (AST)
Received: by wx-out-0506.google.com with SMTP id i28so546677wxd
	for <pgsql-sql@postgresql.org>; Thu, 08 Feb 2007 09:42:12 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=bDecla2J0cJWfdTjluOWM5AZgw8BY01Qz4Z9wMOWjp5e+yLNcU295/cg2HnnaoJ0KoI11a6AMIgRFkkiydLnNyCMqBlKCegOeYPWS0auOqrAgpfOW3GtiaaFs1G0QnTaG/OnoTNtwGStqDZ0pzgc3Xa2bufTMvpLssWpCyo9gtI=
Received: by 10.100.132.16 with SMTP id f16mr11331488and.1170956532224;
	Thu, 08 Feb 2007 09:42:12 -0800 (PST)
Received: by 10.66.217.13 with HTTP; Thu, 8 Feb 2007 09:42:11 -0800 (PST)
Message-ID: <55c095e90702080942x5c07d168u91dde0b2203ada4a@mail.gmail.com>
Date: Thu, 8 Feb 2007 15:42:11 -0200
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: "Andrew Sullivan" <ajs@crankycanuck.ca>
Subject: Re: Open a Transaction
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20070208172715.GC1305@phlogiston.dyndns.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_29670_453738.1170956531985"
References: <55c095e90702080850re95fc47j95afdea67579c933@mail.gmail.com>
	<1170953767.697.44.camel@pampa>
	<55c095e90702080913k5a769f28x8946f252f02571cb@mail.gmail.com>
	<20070208172715.GC1305@phlogiston.dyndns.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200702/100
X-Sequence-Number: 27434

------=_Part_29670_453738.1170956531985
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I increase the "max_stack_depth" and the In statemen run OK.

I don't know if it is good to put this variable as big as possible or as th=
e
manual report (using ulimit -s) to put the larger stack capacity of
Operational System.

Ezequias

2007/2/8, Andrew Sullivan <ajs@crankycanuck.ca>:
>
> On Thu, Feb 08, 2007 at 03:13:16PM -0200, Ezequias Rodrigues da Rocha
> wrote:
> >
> > Any suggestion instead of change my max_stack_depth ?
>
> Well, I suppose you could put the numbers in a temp table an NOT IN
> on that.
>
> A
>
> --
> Andrew Sullivan  | ajs@crankycanuck.ca
> The fact that technology doesn't work is no bar to success in the
> marketplace.
>                 --Philip Greenspun
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>



--=20
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

------=_Part_29670_453738.1170956531985
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I increase the &quot;<tt class=3D"VARNAME">max_stack_depth&quot; and the In=
 statemen run OK.<br><br>I don&#39;t know if it is good to put this variabl=
e as big as possible or as the manual report (using ulimit -s) to put the l=
arger stack capacity of Operational System.
<br><br>Ezequias<br></tt><br><div><span class=3D"gmail_quote">2007/2/8, And=
rew Sullivan &lt;<a href=3D"mailto:ajs@crankycanuck.ca">ajs@crankycanuck.ca=
</a>&gt;:</span><blockquote class=3D"gmail_quote" style=3D"border-left: 1px=
 solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Thu, Feb 08, 2007 at 03:13:16PM -0200, Ezequias Rodrigues da Rocha wrote=
:<br>&gt;<br>&gt; Any suggestion instead of change my max_stack_depth ?<br>=
<br>Well, I suppose you could put the numbers in a temp table an NOT IN
<br>on that.<br><br>A<br><br>--<br>Andrew Sullivan&nbsp;&nbsp;| <a href=3D"=
mailto:ajs@crankycanuck.ca">ajs@crankycanuck.ca</a><br>The fact that techno=
logy doesn&#39;t work is no bar to success in the marketplace.<br>&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;--Philip Greenspun
<br><br>---------------------------(end of broadcast)----------------------=
-----<br>TIP 3: Have you checked our extensive FAQ?<br><br>&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a hre=
f=3D"http://www.postgresql.org/docs/faq">http://www.postgresql.org/docs/faq
</a><br></blockquote></div><br><br clear=3D"all"><br>-- <br> =3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D<br>&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;Atenciosamente (Sincerely)<br>&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ezequias Rodrigues da Ro=
cha
<br> =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-<br>A pior das democracias ainda =E9 melhor do que a melhor das ditaduras<=
br>The worst of democracies is still better than the better of dictatorship=
s
<br><a href=3D"http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blo=
gspot.com/</a>

------=_Part_29670_453738.1170956531985--