sql disaster - subquery error but delete continues - Mailing list pgsql-sql

From Greg Caulton
Subject sql disaster - subquery error but delete continues
Date
Msg-id AANLkTi=KP2hDszZDeaYNROKfJx0N85Tbe5iwK9q+w+j1@mail.gmail.com
Whole thread Raw
Responses Re: sql disaster - subquery error but delete continues  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-sql
delete from form_record_details where form_record_id in (select form_record_id from forms where form_id= 40003656)<br
/><br/>Seems fine at 1am.<br /><br />However the subquery has a typo in it - there is no form_record_id in the forms
table<br/><br />But rather than psql throwing an error...<br /><br />it deletes every row in the form_record_details
table<br/><br />please tell me this is fixed since 8.3<br /><br />Greg<br /> 

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Controlling join order with parenthesis
Next
From: Thomas Kellerer
Date:
Subject: Re: sql disaster - subquery error but delete continues