Андрей Репко <repko@sart.must-ipra.com> writes:
> When I try to execute the next SQL statement, sever was crashed:
> DELETE FROM ma_data WHERE id in (-1,212803,..... );
> ... - is 500k text like id separated by ",". Its about 100000 values.
I wouldn't be too surprised that that ran the server out of memory. The
recovery ought to be a little more graceful though :-( ... and it is, on
my machine:
ERROR: stack depth limit exceeded
HINT: Increase the configuration parameter "max_stack_depth".
CONTEXT: SQL statement "DELETE FROM ma_data WHERE id in (1,2,3,4,5,6,7,8,
... much omitted ...
99990,99991,99992,99993,99994,99995,99996,99997,99998,99999,100000,0);"PL/pgSQL function "blowup" line 7 at execute
statement
I'm guessing something wrong with the stack depth check on Windows.
It's passing the regression test though, so maybe the issue is specific
to your machine? What variant of Windows have you got exactly?
regards, tom lane