Re: Open a Transaction

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(at)freedomcircle(dot)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/