Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0C4229FB3A4 for ; Thu, 8 Feb 2007 13:23:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 96691-05 for ; Thu, 8 Feb 2007 13:23:50 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.251]) by postgresql.org (Postfix) with ESMTP id 85EB59FB389 for ; Thu, 8 Feb 2007 13:13:17 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c24so533107ana for ; Thu, 08 Feb 2007 09:13:17 -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=rLnS0sW4r6ur+VhlvIPO4eifluxcZB18gl03WfOfVOEhGOSBhQJQaMn8FsmeI1lBFHhXFded+FkWHLCEQi5BVj9fB3Hy7pg+SnG7LAcrwuGG5/ztNefbDPPeaIbKtAIa1zh/zCzPu4MDd2t9IPdRCL3xv8tEOfDjD3nUO2PBCc8= Received: by 10.100.124.5 with SMTP id w5mr5821200anc.1170954796960; Thu, 08 Feb 2007 09:13:16 -0800 (PST) Received: by 10.66.217.13 with HTTP; Thu, 8 Feb 2007 09:13:16 -0800 (PST) Message-ID: <55c095e90702080913k5a769f28x8946f252f02571cb@mail.gmail.com> Date: Thu, 8 Feb 2007 15:13:16 -0200 From: "Ezequias Rodrigues da Rocha" To: Joe Subject: Re: Open a Transaction Cc: pgsql-sql@postgresql.org In-Reply-To: <1170953767.697.44.camel@pampa> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_29310_8772819.1170954796656" References: <55c095e90702080850re95fc47j95afdea67579c933@mail.gmail.com> <1170953767.697.44.camel@pampa> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/96 X-Sequence-Number: 27430 ------=_Part_29310_8772819.1170954796656 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Now the sql is OK but now I have the following error: ERROR: stack depth limit exceeded SQL state: 54001 Hint: Increase the configuration parameter "max_stack_depth". In the previous e-mail I hide the numbers of itens of my set (in(234,12332,1232,....) actually I have more than 36000 subsets of my IN statement. :\ Any suggestion instead of change my max_stack_depth ? Regards Ezequias 2007/2/8, Joe : > > Hi Ezequias, > > On Thu, 2007-02-08 at 14:50 -0200, Ezequias Rodrigues da Rocha wrote: > > Hi list, > > > > Could someone tell me what is wrong on this statement ? > > > > Start Transaction > > The above should read > > begin; > > > delete from base.something > > where > > id in( > > 41503, > > 41504, > > 41505, > > 41506, > > 41507, > > 41508, > > 41509, > > 41510, > > 41511, > > 41512, > > 41513, > > 41514, > > 41515, > > 41516, > > 41517, > > 41518, > > 41519, > > 41520, > > 41521, > > 41522, > > 41523, > > 41524, > > 41525, > > 41526, > > 41527, > > 41528, > > Remove the extra comma. > > > ) > > end; > > Remove 'end'. > > > Commit; > > Joe > > --=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_29310_8772819.1170954796656 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Now the sql is OK but now I have the following error:

ERROR: stack d= epth limit exceeded
SQL state: 54001
Hint: Increase the configuration= parameter "max_stack_depth".

In the previous e-mail I hid= e the numbers of itens of my set=20 (in(234,12332,1232,....) actually= I have more than 36000 subsets of my IN statement.

:\

Any s= uggestion instead of change my max_stack_depth ?

Regards
Ezequias

2007/2/8, Joe <dev@freedomcircle.net >:

H= i Ezequias,

On Thu, 2007-02-08 at 14:50 -0200, Ezequias Rodrigues da= Rocha wrote:
> Hi list,
>
> Could someone tell me what is wrong on th= is statement ?
>
> Start Transaction

The above should re= ad

begin;

> delete from base.something
> where
> id in(
> 41503,
> 41504,
> 41505,
> 41506,
= > 41507,
> 41508,
> 41509,
> 41510,
> 41511,
= > 41512,
> 41513,
> 41514,
> 41515,
> 41516,
> 41517,
> 41518,
> 41519,
> 41520,
> 41521,=
> 41522,
> 41523,
> 41524,
> 41525,
> 41526,=
> 41527,
> 41528,

Remove the extra comma.

> )
> end;

Remove 'end'.

> Commit;

Joe

--
=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
&= nbsp; &nbs= p; &= nbsp; Atenciosamente (Sincerely)
= ; Ez= equias 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 th= e better of dictatorships
http://ezequiasrocha.blo= gspot.com/ ------=_Part_29310_8772819.1170954796656--