Postgres Pro
Downloads
Home   >   mailing lists

"stack depth limit exceeded" executing DELETE FROM - Mailing list pgsql-jdbc

From Cox, Brian
Subject "stack depth limit exceeded" executing DELETE FROM
Date
Msg-id 3240464A2687334E92AAB86DAB6504530132D21B@USILMS13.ca.com
Whole thread Raw
Responses Re: "stack depth limit exceeded" executing DELETE FROM  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: "stack depth limit exceeded" executing DELETE FROM  (Mark Lewis <mark.lewis@mir3.com>)
Re: "stack depth limit exceeded" executing DELETE FROM  (Michael Fuhr <mike@fuhr.org>)
List pgsql-jdbc
Tree view

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 by date:

Previous
From: "Trygve Hardersen"
Date:
Subject: Re: Strange JDBC problem
Next
From: Andreas Reichel
Date:
Subject: compress a resultset