From: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
To: Joe <dev@freedomcircle.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Open a Transaction
Date: Thu, 8 Feb 2007 15:13:16 -0200
Message-ID: <55c095e90702080913k5a769f28x8946f252f02571cb@mail.gmail.com> (raw)
In-Reply-To: <1170953767.697.44.camel@pampa>
References: <55c095e90702080850re95fc47j95afdea67579c933@mail.gmail.com>
<1170953767.697.44.camel@pampa>
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 <dev@freedomcircle.net >:
>
> 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
>
>
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ezequias.rocha@gmail.com, dev@freedomcircle.net
Subject: Re: Open a Transaction
In-Reply-To: <55c095e90702080913k5a769f28x8946f252f02571cb@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox