[EMAIL PROTECTED] wrote: > On Thu, Aug 07, 2008 at 03:58:51PM -0400, Tom Lane wrote: > > [EMAIL PROTECTED] writes: > > > I have tried to do this before and always found a way, usually > > > > > DELETE FROM a WHERE a.b_id IN (SELECT id FROM b WHERE second_id = ?) > > > > > but I have too many rows, millions, in the IN crowd, ha ha, and it > > > barfs. > > > > Define "barfs". That seems like the standard way to do it, and it > > should work. > > In this case, the first database I tried was Oracle, and it complained > of too much transactional data; I forget the exact wording now.
I suggest you do not assume that Oracle implementation details apply to Postgres, because they do not, most of the time. They certainly don't in this case. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
