The following bug has been logged online: Bug reference: 4220 Logged by: Lon Varscsak Email address: [EMAIL PROTECTED] 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! -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
