sql disaster - subquery error but delete continues

From: Greg Caulton <caultonpos(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: sql disaster - subquery error but delete continues
Date: 2010-09-10 09:46:35
Message-ID: AANLkTi=KP2hDszZDeaYNROKfJx0N85Tbe5iwK9q+w+j1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

delete from form_record_details where form_record_id in (select
form_record_id from forms where form_id= 40003656)

Seems fine at 1am.

However the subquery has a typo in it - there is no form_record_id in the
forms table

But rather than psql throwing an error...

it deletes every row in the form_record_details table

please tell me this is fixed since 8.3

Greg

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Kellerer 2010-09-10 10:07:37 Re: sql disaster - subquery error but delete continues
Previous Message Tom Lane 2010-09-09 13:49:45 Re: Controlling join order with parenthesis