The following bug has been logged online:
Bug reference: 4220
Logged by: Lon Varscsak
Email address: varscsak(at)smarthealth(dot)com
PostgreSQL version: 8.3.1
Operating system: Linux (RHEL 5)
Description: delete statement deleted too many rows
Details:
I executed this query:
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.
Yikes!