"stack depth limit exceeded" executing DELETE FROM

Поиск
Список
Период
Сортировка
Искать
От
Cox, Brian
Тема
"stack depth limit exceeded" executing DELETE FROM
Дата
Msg-id
3240464A2687334E92AAB86DAB6504530132D21B@USILMS13.ca.com
Список
Дерево обсуждения
"stack depth limit exceeded" executing DELETE FROM "Cox, Brian" <Brian.Cox@ca.com>
Re: "stack depth limit exceeded" executing DELETE FROM Mark Lewis <mark.lewis@mir3.com>
Re: "stack depth limit exceeded" executing DELETE FROM Tom Lane <tgl@sss.pgh.pa.us>
Re: "stack depth limit exceeded" executing DELETE FROM Michael Fuhr <mike@fuhr.org>
Re: "stack depth limit exceeded" executing DELETE FROM AgentM <agentm@themactionfaction.com>

The following fails with a "stack depth limit exceeded":

DELETE FROM some-table WHERE pk IN (pk1, pk2, ..., pkN)

where pk = primary key and N is large, may be > 50000.

Is there some limit as to the number of rows that can
be deleted in a single DELETE?

Thanks,
Brian

В списке pgsql-jdbc по дате отправления
От: Trygve Hardersen
Дата:
Сообщение: Re: Strange JDBC problem
От: Andreas Reichel
Дата:
Сообщение: compress a resultset
FAQ