On Wed, Jun 04, 2008 at 06:46:42PM +0000, Lon Varscsak wrote:
> delete from customer_transactions_detail where transaction_id in (select
> transaction_id from test);
> The transaction_id column does NOT exist in the temporary table named
> 'test'). I would think this would just result in an error, instead it
> delete all rows in the customer_transactions_detail table.
what you got is so called "correlated subquery", and is perfectly valid
- even if it's surprising sometimes.
i wrote about it in more details in here:
anyway - it's definitely not a bug.
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2008-06-04 20:08:09|
|Subject: Re: BUG #4220: delete statement deleted too many rows |
|Previous:||From: Tom Lane||Date: 2008-06-04 18:48:20|
|Subject: Re: BUG #4219: fseeko test failure in configure script |