Re: DELETE with JOIN

From: Christophe <xof(at)thebuild(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: DELETE with JOIN
Date: 2008-08-07 21:42:10
Message-ID: 5A724102-E3A4-4240-A90C-8F03AB3ADC44@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Aug 7, 2008, at 2:39 PM, felix(at)crowfix(dot)com wrote:
> In this case, the first database I tried was Oracle, and it complained
> of too much transactional data; I forget the exact wording now.

You might try it on PostgreSQL. While it might have to spill the
result of the subquery to disk, it shouldn't actually fail unless
disk is very constrained.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Alvaro Herrera 2008-08-07 22:12:32 Re: DELETE with JOIN
Previous Message felix 2008-08-07 21:39:27 Re: DELETE with JOIN