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 the
manual report (using ulimit -s) to put the larger stack capacity of
Operational System.
Ezequias
2007/2/8, Andrew Sullivan <[EMAIL PROTECTED]>:
On Thu, Feb
"Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> writes:
> 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
>
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 | [EMAIL PROTECTED]
The fact that technology doesn't work is
At 17.50 08/02/2007, Ezequias Rodrigues da Rocha wrote:
>Hi list,
>
>Could someone tell me what is wrong on this statement ?
>
>Start Transaction
>delete from base.something
>where
>id in(
>41503,
>41504,
>41505,
>41506,
>41507,
>41508,
>41509,
>41510,
>41511,
>41512,
>41513,
>41514,
>41515,
>41516
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
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,
> 415
