"stack depth limit exceeded" executing DELETE FROM

From: "Cox, Brian" <Brian(dot)Cox(at)ca(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: "stack depth limit exceeded" executing DELETE FROM
Date: 2006-09-05 18:18:05
Message-ID: 3240464A2687334E92AAB86DAB6504530132D21B@USILMS13.ca.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Fuhr 2006-09-05 18:44:50 Re: "stack depth limit exceeded" executing DELETE FROM
Previous Message Andreas Reichel 2006-09-05 09:16:45 compress a resultset