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

Reply via email to